Engine 'hiveserver2' doesn't support databases

tagomoris commented 10 years ago

Currently disabled databases in engine 'hiveserver2', because of partition listing.

HiveServer2 rejects queries like use dbname
- used for show partitions tablename
- problem details are not investigated yet
show partitions doesn't support expression like dbname.tablename
- Hive 0.13 will support it

tagomoris commented 10 years ago

On hive 0.13, use DBNAME over TCLIService still fails w/ stacktrace below.

2014-07-04 17:10:49,649 WARN  [pool-5-thread-5]: thrift.ThriftCLIService (ThriftCLIService.java:FetchResults(540)) - Error fetching results: 
java.lang.NullPointerException
        at org.apache.hive.service.cli.RowBasedSet.<init>(RowBasedSet.java:40)
        at org.apache.hive.service.cli.RowSetFactory.create(RowSetFactory.java:32)
        at org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:290)
        at org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:192)
        at org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:471)
        at org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:405)
        at org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:532)
        at org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1553)
        at org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1538)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
        at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:55)
        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)

tagomoris commented 10 years ago

Fixed on 062f315a917bae7aa6e85cb48d51bda24e09a0ee

tagomoris / shib

Engine 'hiveserver2' doesn't support databases #6