Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB