Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Error with Meta Data from >> SELECT 0 as mx


Copy link to this message
-
Error with Meta Data from >> SELECT 0 as mx
Hi,

It seems there are a bug in trunk version.

When I'm doing this query :

create table mag_new as
SELECT row_sequence() + tbl.mx, nommagasin, idsociete, idregion,
codepostal from magasin, (select 0 as mx) as tbl;

Metastore complains about missing table : _dummy_database._dummy_table
Complete log :

2014-08-19 12:05:02,673 ERROR [pool-5-thread-3]: stats.StatsUtils
(StatsUtils.java:getTableColumnStats(474)) - Failed to retrieve table
statistics:
org.apache.hadoop.hive.ql.metadata.HiveException:
NoSuchObjectException(message:Specified database/table does not exist :
_dummy_database._dummy_table)
         at
org.apache.hadoop.hive.ql.metadata.Hive.getTableColumnStatistics(Hive.java:2563)
         at
org.apache.hadoop.hive.ql.stats.StatsUtils.getTableColumnStats(StatsUtils.java:470)
         at
org.apache.hadoop.hive.ql.stats.StatsUtils.collectStatistics(StatsUtils.java:147)
         at
org.apache.hadoop.hive.ql.optimizer.stats.annotation.StatsRulesProcFactory$TableScanStatsRule.process(StatsRulesProcFactory.java:100)
         at
org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90)
         at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:94)
         at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:78)
         at
org.apache.hadoop.hive.ql.lib.PreOrderWalker.walk(PreOrderWalker.java:54)
         at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:109)
         at
org.apache.hadoop.hive.ql.optimizer.stats.annotation.AnnotateWithStatistics.transform(AnnotateWithStatistics.java:78)
         at
org.apache.hadoop.hive.ql.optimizer.Optimizer.optimize(Optimizer.java:149)
         at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9484)
         at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:208)
         at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:413)
         at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:309)
         at
org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1003)
         at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:997)
         at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:99)
         at
org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:170)
         at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:306)
         at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:293)
         at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
         at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:606)
         at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:79)
         at
org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:37)
         at
org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:64)
         at java.security.AccessController.doPrivileged(Native Method)
         at javax.security.auth.Subject.doAs(Subject.java:415)
         at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1548)
         at
org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
         at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:60)
         at com.sun.proxy.$Proxy21.executeStatementAsync(Unknown Source)
         at
org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:259)
         at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:346)
         at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)
         at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)
         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:744)
Damien CAROL

  * tél : +33 (0)4 74 96 88 14
  * fax : +33 (0)4 74 96 31 88
  * email :[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

BLITZ BUSINESS SERVICE