Member since
05-05-2015
2
Posts
0
Kudos Received
0
Solutions
06-03-2015
12:40 PM
I think the point of Sean's post is that you shouldn't use the standard shell -- Try using the Beeline shell instead -- if that doesn't help maybe the community will weigh in. Good luck.
... View more
05-05-2015
01:28 PM
I am working through the quickstart tutorial and am experiencing errors with the HUE Hive Editor using the below SQL; upon execution the editor parses the output.format.string property and throws up a dialog requesting parameter "s"... Sorry if this is a FAQ, but couldn't find any reference to it in the community forums mnsm CREATE EXTERNAL TABLE intermediate_access_logs ( ip STRING, date STRING, method STRING, url STRING, http_version STRING, code1 STRING, code2 STRING, dash STRING, user_agent STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.ou' WITH SERDEPROPERTIES ( 'input.regex' = '([^ ]*) - - \\[([^\\]]*)\\] "([^\ ]*) ([^\ ]*) ([^\ ]*)" (\\d*) (\\d*) "([^"]*)" "([^"]*)"', 'output.format.string' = '%1$s %2$s %3$s %4$s %5$s %6$s %7$s %8$s %9$s' ) LOCATION '/user/hive/warehouse/original_access_logs'; /*... downstream activities elided */ DROP TABLE intermediate_access_logs; !quit
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
-
Cloudera Hue