Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Beeline problem in Tutorial 3

Highlighted

Beeline problem in Tutorial 3

New Contributor

I am going through the tutorial and could get Beeline to work. Did anyone face this issue?

The error message I got was - Error: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near '0' ':' 'jdbc' (state=42000,code=4000)

 

 

 

[cloudera@quickstart ~]$ beeline -u jdbc:hive2://quickstart:10000/default -n admin -d org.apache.hive.jdbc.HiveDriver
Connecting to jdbc:hive2://quickstart:10000/default
Connected to: Apache Hive (version 1.1.0-cdh5.4.2)
Driver: Hive JDBC (version 1.1.0-cdh5.4.2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0-cdh5.4.2 by Apache Hive
0: jdbc:hive2://quickstart:10000/default> 0: jdbc:hive2://quickstart:10000/default> CREATE EXTERNAL TABLE intermediate_access_logs (
0: jdbc:hive2://quickstart:10000/default> ip STRING,
0: jdbc:hive2://quickstart:10000/default> date STRING,
0: jdbc:hive2://quickstart:10000/default> method STRING,
0: jdbc:hive2://quickstart:10000/default> url STRING,
0: jdbc:hive2://quickstart:10000/default> http_version STRING,
0: jdbc:hive2://quickstart:10000/default> code1 STRING,
0: jdbc:hive2://quickstart:10000/default> code2 STRING,
0: jdbc:hive2://quickstart:10000/default> dash STRING,
0: jdbc:hive2://quickstart:10000/default> user_agent STRING)
0: jdbc:hive2://quickstart:10000/default> ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
0: jdbc:hive2://quickstart:10000/default> WITH SERDEPROPERTIES (
0: jdbc:hive2://quickstart:10000/default> 'input.regex' = '([^ ]*) - - \\[([^\\]]*)\\] "([^\ ]*) ([^\ ]*) ([^\ ]*)" (\\d*) (\\d*) "([^"]*)" "([^"]*)"',
0: jdbc:hive2://quickstart:10000/default> 'output.format.string' = "%1$s %2$s %3$s %4$s %5$s %6$s %7$s %8$s %9$s"
0: jdbc:hive2://quickstart:10000/default> )
0: jdbc:hive2://quickstart:10000/default> LOCATION '/user/hive/warehouse/original_access_logs';
Error: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near '0' ':' 'jdbc' (state=42000,code=40000)