Create hive table error to load Twitter data

You can also use this to disable the check :

SET hive.support.sql11.reserved.keywords=false;

hadoop twitter hive flume bigdata

If you look at https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL you can see a list of reserved keywords, of which user is one. You can't name a column user.

You can name it `user` if you want, and then your queries would look like

SELECT `user` FROM table;

but as you can see that's a bit ugly so it's probably better to pick a different column name.

CodeHunter