Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Beeline problem in Tutorial 3

avatar
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)

Who agreed with this topic