It seems that the Thrift server you connected to is the original
HiveServer2 rather than Spark SQL HiveThriftServer2.
On 12/19/14 4:08 PM, jeanlyn92 wrote:
when i run the *"cache table as" *in the beeline which communicate
with the thrift server i got the follow error:
14/12/19 15:57:05 ERROR ql.Driver: FAILED: ParseException line 1:0
cannot recognize input near 'cache' 'table' 'jeanlyntest'
org.apache.hadoop.hive.ql.parse.ParseException: line 1:0 cannot
recognize input near 'cache' 'table' 'jeanlyntest'
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:193)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:418)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:337)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:909)
at
org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:95)
In Spark SQL HiveThriftServer2, this line should be
`org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.run`
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:180)
at
org.apache.hive.service.cli.CLIService.executeStatement(CLIService.java:152)
at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:203)
at
org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:186)
at org.apache.hive.beeline.Commands.execute(Commands.java:750)
at org.apache.hive.beeline.Commands.sql(Commands.java:675)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:759)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:631)
at
org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:380)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:364)
14/12/19 15:57:05 INFO ql.Driver: </PERFLOG method=compile
start=1418975825444 end=1418975825972 duration=528>
14/12/19 15:57:05 INFO ql.Driver: <PERFLOG method=releaseLocks>
14/12/19 15:57:05 INFO ql.Driver: </PERFLOG method=releaseLocks
start=1418975825973 end=1418975825973 duration=0>
org.apache.hive.service.cli.HiveSQLException: Error while processing
statement: FAILED: ParseException line 1:0 cannot recognize input near
'cache' 'table' 'jeanlyntest'
at
org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:97)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:180)
at
org.apache.hive.service.cli.CLIService.executeStatement(CLIService.java:152)
at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:203)
at
org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:186)
at org.apache.hive.beeline.Commands.execute(Commands.java:750)
at org.apache.hive.beeline.Commands.sql(Commands.java:675)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:759)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:631)
at
org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:380)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:364)
Error: Error while processing statement: FAILED: ParseException line
1:0 cannot recognize input near 'cache' 'table' 'jeanlyntest'
(state=42000,code=40000)
Error: Error while processing statement: FAILED: ParseException line
1:0 cannot recognize input near 'cache' 'table' 'jeanlyntest'
(state=42000,code=40000)
is that the Thrift server doesn't support this feature now?
Regards,
Jeanlyn
