@Edgar Daeds See this https://community.hortonworks.com/content/kbentry/2947/new-visualization-feature-in-hive-view.html ... View more

@vinay kumar Whats the output of df -h in slave 4? You can add /hadoop and restart HDFS and then you can remove other mounts from the settings. ... View more

@Edgar Daeds I used Hue was a year ago because of Ambari views http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.1.0/bk_ambari_views_guide/content/ch_using_hive_view.html ... View more

@vinay kumar As expected, the problem is with the disks allocated to datanode settings. Ambari picks up all the mounts except /boot and /mnt You were suppose to modify the settings during the installs. As you can see, data is going on /opt and other mounts and you were suppose to give only /hadoop " / has 400GB" Now , there is no way we want to store the data on /tmp /opt/hadoop/hdfs/data,/tmp/hadoop/hdfs/data,/usr/hadoop/hdfs/data,/usr/local/hadoop/hdfs/data You need to create a directory as /hadoop and modify the settings to read the data from /hadoop. ... View more

@vinay kumar What do you have for dfs.datanode.data.dir? slave 4 --> / ? Rest of the nodes are using other mounts... ... View more

@Michael Dennis Uanang See this hive> create table test5 (create string); FailedPredicateException(identifier,{useSQL11ReservedKeywordsForIdentifier()}?) at org.apache.hadoop.hive.ql.parse.HiveParser_IdentifiersParser.identifier(HiveParser_IdentifiersParser.java:11644) at org.apache.hadoop.hive.ql.parse.HiveParser.identifier(HiveParser.java:45920) at org.apache.hadoop.hive.ql.parse.HiveParser.columnNameType(HiveParser.java:38052) at org.apache.hadoop.hive.ql.parse.HiveParser.columnNameTypeList(HiveParser.java:36183) at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:5222) at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:2648) at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1658) at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1117) at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:202) at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:428) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:316) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1181) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1229) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1118) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1108) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:216) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:168) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:379) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:739) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:684) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:624) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) FAILED: ParseException line 1:20 Failed to recognize predicate 'create'. Failed rule: 'identifier' in column specification hive> ... View more

@Saurabh Kumar You may want to open a support ticket and update that jira with your findings. ... View more