hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-17279) spark/bin/beeline throws Unknown column 'A0.IS_REWRITE_ENABLED' in 'field list'
Date Wed, 09 Aug 2017 07:41:01 GMT

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

Mime
View raw message