[
https://issues.apache.org/jira/browse/HIVE-17279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gopal V resolved HIVE-17279.
----------------------------
Resolution: Invalid
spark/bin/beeline is not part of this code base - this is a BUG in Spark
project.
https://github.com/apache/spark/blob/master/bin/beeline
>From a quick look, the error is related to Materialized Views support in Hive
>2.0.
> spark/bin/beeline throws Unknown column 'A0.IS_REWRITE_ENABLED' in 'field
> list'
> -------------------------------------------------------------------------------
>
> Key: HIVE-17279
> URL: https://issues.apache.org/jira/browse/HIVE-17279
> Project: Hive
> Issue Type: Bug
> Components: Beeline
> Affects Versions: 2.1.0
> Environment: spark 2.10. , hive 2.1.0
> Reporter: saurab
>
> up vote
> 0
> down vote
> favorite
> If I run this code on /spark/bin/beeline
> CREATE EXTERNAL TABLE IF NOT EXISTS foods_txt (
> name string,
> type string
> ) ROW FORMAT delimited fields terminated by ','
> STORED AS TEXTFILE
> LOCATION 'hdfs://<host>:9000/hello'
> I get
> Error: javax.jdo.JDOFatalInternalException: The initCause method cannot be
> used. To set the cause of this exception, use a constructor with a
> Throwable[] argument. (state=08S01,code=0)
> and /tmp//hive.log shows
> 2017-08-09T02:21:14,427 WARN [HiveServer2-Handler-Pool: Thread-39]
> thrift.ThriftCLIService: Error executing statement:
> org.apache.hive.service.cli.HiveSQLException: Error while compiling
> statement: FAILED: IllegalStateException Unexpected Exception thrown: Unab$
> at
> org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:380)
> ~[hive-service-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:206)
> ~[hive-service-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:290)
> ~[hive-service-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.cli.operation.Operation.run(Operation.java:320)
> ~[hive-service-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:530)
> ~[hive-service-2.3.0.jar:2.3$
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:517)
> ~[hive-service-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:310)
> ~[hive-service-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:530)
> ~[hive-service-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1437)
> ~[hive-exec-2.3.0.jar:2.$
> at
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1422)
> ~[hive-exec-2.3.0.jar:2.$
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
> ~[hive-service-2.3.0.jar:2.3.0]
> at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [?:1.8.0_131]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [?:1.8.0_131]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
> Caused by: java.lang.IllegalStateException: Unexpected Exception thrown:
> Unable to fetch table foods_txt. Exception thrown when executing quer$
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeCreateTable(SemanticAnalyzer.java:12000)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:11001)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:11114)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:286)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:258)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:511)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1316)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at
> org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1294)
> ~[hive-exec-2.3.0.jar:2.3.0]
> at
> org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:204)
> ~[hive-service-2.3.0.jar:2.3.0]
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
> column 'A0.IS_REWRITE_ENABLED' in 'field list'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[?:1.8.0_131]
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> ~[?:1.8.0_131]
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> ~[?:1.8.0_131]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> ~[?:1.8.0_131]
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at com.mysql.jdbc.Util.getInstance(Util.java:387)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
> ~[mysql-connector-java-5.1.38.jar:5.1.38]
> at
> com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:174)
> ~[bonecp-0.8.0.RELEASE.jar:?]
> at
> org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeQuery(ParamLoggingPreparedStatement.java:375)
> ~[datanucleus-rdbms-$
> at
> org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:552)
> ~[datanucleus-rdbms-4.1.19.jar:?]
> at
> org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:617)
> ~[datanucleus-rdbms-4.1.19.jar:?]
> at org.datanucleus.store.query.Query.executeQuery(Query.java:1855)
> ~[datanucleus-core-4.1.17.jar:?]
> at org.datanucleus.store.query.Query.executeWithArray(Query.java:1744)
> ~[datanucleus-core-4.1.17.jar:?]
> at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:368)
> ~[datanucleus-api-jdo-4.2.4.jar:?]
> file on hdfs exists and hiveserver2 and metastore service are up. I can
> connect to metastore with jdbc:hive2://<user>:10000/<database> <user>
> <password> and can create database <database>, but up creating external table
> I get that exception.I plan to use hive metastore with spark accessing it's
> data and to test I am using beeline
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
