免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › IT运维 › Hadoop和大数据技术 › hive，show table是不
最近访问板块 发新帖
查看: 2633 | 回复: 1

[Hive] hive，show table是不 [复制链接]

zhaopingzi

论坛徽章:
71
15-16赛季CBA联赛之同曦 日期:2018-08-23 15:41:42辰龙 日期:2014-08-15 09:07:43狮子座 日期:2014-06-03 13:55:33亥猪 日期:2014-06-02 11:17:08巨蟹座 日期:2014-05-06 10:02:03午马 日期:2014-05-04 08:18:27亥猪 日期:2014-04-29 11:11:32技术图书徽章 日期:2014-04-24 15:51:26技术图书徽章 日期:2014-04-17 11:01:53辰龙 日期:2014-04-15 12:45:46亥猪 日期:2014-04-11 09:06:23射手座 日期:2014-04-01 15:28:10
发表于 2013-12-11 09:36 |显示全部楼层


  3. hive> show tables;
  4. 13/12/11 09:36:30 INFO ql.Driver: <PERFLOG method=Driver.run>
  5. 13/12/11 09:36:30 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
  6. 13/12/11 09:36:30 INFO ql.Driver: <PERFLOG method=compile>
  7. 13/12/11 09:36:30 DEBUG parse.VariableSubstitution: Substitution is on: show tables
  8. 13/12/11 09:36:30 INFO ql.Driver: <PERFLOG method=parse>
  9. 13/12/11 09:36:30 INFO parse.ParseDriver: Parsing command: show tables
  10. 13/12/11 09:36:31 INFO parse.ParseDriver: Parse Completed
  11. 13/12/11 09:36:31 INFO ql.Driver: </PERFLOG method=parse start=1386725790703 end=1386725791029 duration=326>
  12. 13/12/11 09:36:31 INFO ql.Driver: <PERFLOG method=semanticAnalyze>
  13. 13/12/11 09:36:31 DEBUG fs.FileSystem: Creating filesystem for file:///
  14. 13/12/11 09:36:31 DEBUG util.NativeCodeLoader: Trying to load the custom-built native-hadoop library...
  15. 13/12/11 09:36:31 INFO util.NativeCodeLoader: Loaded the native-hadoop library
  16. 13/12/11 09:36:31 INFO ql.Driver: Semantic Analysis Completed
  17. 13/12/11 09:36:31 INFO ql.Driver: </PERFLOG method=semanticAnalyze start=1386725791030 end=1386725791311 duration=281>
  18. 13/12/11 09:36:31 DEBUG conf.Configuration: java.io.IOException: config(config)
  19.         at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:260)
  20.         at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:341)
  21.         at org.apache.hadoop.hive.ql.exec.FetchTask.initialize(FetchTask.java:68)
  22.         at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:482)
  23.         at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:342)
  24.         at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:977)
  25.         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
  26.         at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
  27.         at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
  28.         at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
  29.         at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
  30.         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
  31.         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
  32.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  33.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  34.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  35.         at java.lang.reflect.Method.invoke(Method.java:606)
  36.         at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

  38. 13/12/11 09:36:31 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[tab_name] columnTypes=[string] separator=[[B@33614c61] nullstring=  lastColumnTakesRest=false
  39. 13/12/11 09:36:31 INFO exec.ListSinkOperator: Initializing Self 0 OP
  40. 13/12/11 09:36:31 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.DelimitedJSONSerDe initialized with: columnNames=[] columnTypes=[] separator=[[B@6e51e55a] nullstring=  lastColumnTakesRest=false
  41. 13/12/11 09:36:31 INFO exec.ListSinkOperator: Operator 0 OP initialized
  42. 13/12/11 09:36:31 INFO exec.ListSinkOperator: Initialization Done 0 OP
  43. 13/12/11 09:36:31 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[tab_name] columnTypes=[string] separator=[[B@50ce2e1d] nullstring=  lastColumnTakesRest=false
  44. 13/12/11 09:36:31 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer)], properties:null)
  45. 13/12/11 09:36:31 INFO ql.Driver: </PERFLOG method=compile start=1386725790603 end=1386725791575 duration=972>
  46. 13/12/11 09:36:31 INFO ql.Driver: <PERFLOG method=Driver.execute>
  47. 13/12/11 09:36:31 INFO ql.Driver: Starting command: show tables
  48. 13/12/11 09:36:31 INFO ql.Driver: </PERFLOG method=TimeToSubmit start=1386725790603 end=1386725791672 duration=1069>
  49. 13/12/11 09:36:31 INFO ql.Driver: <PERFLOG method=runTasks>
  50. 13/12/11 09:36:31 INFO ql.Driver: <PERFLOG method=task.DDL.Stage-0>
  51. 13/12/11 09:36:31 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
  52. 13/12/11 09:36:31 DEBUG conf.Configuration: java.io.IOException: config(config)
  53.         at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:260)
  54.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getConf(HiveMetaStore.java:381)
  55.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:413)
  56.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:402)
  57.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
  58.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
  59.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
  60.         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
  61.         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
  62.         at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
  63.         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
  64.         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  65.         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  66.         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  67.         at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  68.         at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
  69.         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
  70.         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
  71.         at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
  72.         at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
  73.         at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1139)
  74.         at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
  75.         at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2236)
  76.         at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:333)
  77.         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
  78.         at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
  79.         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
  80.         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
  81.         at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
  82.         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
  83.         at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
  84.         at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
  85.         at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
  86.         at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
  87.         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
  88.         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
  89.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  90.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  91.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  92.         at java.lang.reflect.Method.invoke(Method.java:606)
  93.         at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

  95. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.validateConstraints value null from  jpox.properties with false
  96. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.autoCreateSchema value null from  jpox.properties with false
  97. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.cache.level2 value null from  jpox.properties with false
  98. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.ConnectionUserName value null from  jpox.properties with hadoop
  99. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.connectionPoolingType value null from  jpox.properties with DBCP
  100. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.fixedDatastore value null from  jpox.properties with true
  101. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.ConnectionDriverName value null from  jpox.properties with com.mysql.jdbc.Driver
  102. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.validateColumns value null from  jpox.properties with false
  103. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.NonTransactionalRead value null from  jpox.properties with true
  104. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.validateTables value null from  jpox.properties with false
  105. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.rdbms.useLegacyNativeValueStrategy value null from  jpox.properties with true
  106. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.identifierFactory value null from  jpox.properties with datanucleus1
  107. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.cache.level2.type value null from  jpox.properties with SOFT
  108. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.plugin.pluginRegistryBundleCheck value null from  jpox.properties with LOG
  109. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.ConnectionURL value null from  jpox.properties with jdbc:mysql://192.168.7.81:3306/hive?createDatabaseIfNotExist=true
  110. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.autoStartMechanismMode value null from  jpox.properties with checked
  111. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.DetachAllOnCommit value null from  jpox.properties with true
  112. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.storeManagerType value null from  jpox.properties with rdbms
  113. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.transactionIsolation value null from  jpox.properties with read-committed
  114. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.PersistenceManagerFactoryClass value null from  jpox.properties with org.datanucleus.api.jdo.JDOPersistenceManagerFactory
  115. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.Multithreaded value null from  jpox.properties with true
  116. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.rdbms.useLegacyNativeValueStrategy = true
  117. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.autoStartMechanismMode = checked
  118. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.Multithreaded = true
  119. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.identifierFactory = datanucleus1
  120. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.transactionIsolation = read-committed
  121. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.validateTables = false
  122. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.ConnectionURL = jdbc:mysql://192.168.7.81:3306/hive?createDatabaseIfNotExist=true
  123. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.DetachAllOnCommit = true
  124. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.NonTransactionalRead = true
  125. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.fixedDatastore = true
  126. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.validateConstraints = false
  127. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.ConnectionDriverName = com.mysql.jdbc.Driver
  128. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.ConnectionUserName = hadoop
  129. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.validateColumns = false
  130. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.cache.level2 = false
  131. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.plugin.pluginRegistryBundleCheck = LOG
  132. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.cache.level2.type = SOFT
  133. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.PersistenceManagerFactoryClass = org.datanucleus.api.jdo.JDOPersistenceManagerFactory
  134. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.autoCreateSchema = false
  135. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.storeManagerType = rdbms
  136. 13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.connectionPoolingType = DBCP
  137. 13/12/11 09:36:31 INFO metastore.ObjectStore: ObjectStore, initialize called
  138. 13/12/11 09:36:32 DEBUG bonecp.BoneCPDataSource: JDBC URL = jdbc:mysql://192.168.7.81:3306/hive?createDatabaseIfNotExist=true, Username = hadoop, partitions = 1, max (per partition) = 0, min (per partition) = 0, helper threads = 3, idle max age = 60 min, idle test period = 240 min
  139. 13/12/11 09:36:32 WARN bonecp.BoneCPConfig: Max Connections < 1. Setting to 20
  140. 13/12/11 09:36:33 DEBUG conf.Configuration: java.io.IOException: config()
  141.         at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:227)
  142.         at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:214)
  143.         at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1091)
  144.         at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:278)
  145.         at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:304)
  146.         at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:234)
  147.         at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:209)
  148.         at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
  149.         at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
  150.         at org.apache.hadoop.hive.metastore.RetryingRawStore.<init>(RetryingRawStore.java:64)
  151.         at org.apache.hadoop.hive.metastore.RetryingRawStore.getProxy(RetryingRawStore.java:73)
  152.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:415)
  153.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:402)
  154.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
  155.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
  156.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
  157.         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
  158.         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
  159.         at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
  160.         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
  161.         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  162.         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  163.         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  164.         at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  165.         at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
  166.         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
  167.         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
  168.         at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
  169.         at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
  170.         at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1139)
  171.         at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
  172.         at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2236)
  173.         at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:333)
  174.         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
  175.         at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
  176.         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
  177.         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
  178.         at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
  179.         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
  180.         at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
  181.         at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
  182.         at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
  183.         at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
  184.         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
  185.         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
  186.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  187.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  188.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  189.         at java.lang.reflect.Method.invoke(Method.java:606)
  190.         at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

  192. 13/12/11 09:36:33 DEBUG conf.Configuration: java.io.IOException: config()
  193.         at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:227)
  194.         at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:214)
  195.         at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:330)
  196.         at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:1125)
  197.         at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1092)
  198.         at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:278)
  199.         at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:304)
  200.         at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:234)
  201.         at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:209)
  202.         at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
  203.         at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
  204.         at org.apache.hadoop.hive.metastore.RetryingRawStore.<init>(RetryingRawStore.java:64)
  205.         at org.apache.hadoop.hive.metastore.RetryingRawStore.getProxy(RetryingRawStore.java:73)
  206.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:415)
  207.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:402)
  208.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
  209.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
  210.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
  211.         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
  212.         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
  213.         at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
  214.         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
  215.         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  216.         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  217.         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  218.         at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  219.         at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
  220.         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
  221.         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
  222.         at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
  223.         at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
  224.         at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1139)
  225.         at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
  226.         at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2236)
  227.         at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:333)
  228.         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
  229.         at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
  230.         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
  231.         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
  232.         at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
  233.         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
  234.         at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
  235.         at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
  236.         at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
  237.         at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
  238.         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
  239.         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
  240.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  241.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  242.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  243.         at java.lang.reflect.Method.invoke(Method.java:606)
  244.         at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

  246. 13/12/11 09:36:33 INFO metastore.ObjectStore: Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,StorageDescriptor,SerDeInfo,Partition,Database,Type,FieldSchema,Order"
  247. 13/12/11 09:36:33 INFO metastore.ObjectStore: Initialized ObjectStore
  248. 13/12/11 09:36:34 ERROR exec.DDLTask: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
  249.         at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1143)
  250.         at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
  251.         at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2236)
  252.         at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:333)
  253.         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
  254.         at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
  255.         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
  256.         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
  257.         at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
  258.         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
  259.         at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
  260.         at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
  261.         at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
  262.         at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
  263.         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
  264.         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
  265.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  266.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  267.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  268.         at java.lang.reflect.Method.invoke(Method.java:606)
  269.         at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
  270. Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
  271.         at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1212)
  272.         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
  273.         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
  274.         at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
  275.         at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
  276.         at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1139)
  277.         ... 20 more
  278. Caused by: java.lang.reflect.InvocationTargetException
  279.         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  280.         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  281.         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  282.         at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  283.         at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
  284.         ... 25 more
  285. Caused by: MetaException(message:Version information not found in metastore. )
  286.         at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:5638)
  287.         at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:5622)
  288.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  289.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  290.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  291.         at java.lang.reflect.Method.invoke(Method.java:606)
  292.         at org.apache.hadoop.hive.metastore.RetryingRawStore.invoke(RetryingRawStore.java:124)
  293.         at com.sun.proxy.$Proxy10.verifySchema(Unknown Source)
  294.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:403)
  295.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
  296.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
  297.         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
  298.         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
  299.         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
  300.         at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
  301.         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
  302.         ... 30 more

  304. 13/12/11 09:36:34 INFO ql.Driver: </PERFLOG method=task.DDL.Stage-0 start=1386725791672 end=1386725794913 duration=3241>
  305. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
  306. 13/12/11 09:36:34 ERROR ql.Driver: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
  307. 13/12/11 09:36:34 INFO ql.Driver: </PERFLOG method=Driver.execute start=1386725791576 end=1386725794913 duration=3337>
  308. 13/12/11 09:36:34 INFO ql.Driver: <PERFLOG method=releaseLocks>
  309. 13/12/11 09:36:34 INFO ql.Driver: </PERFLOG method=releaseLocks start=1386725794913 end=1386725794913 duration=0>
  310. 13/12/11 09:36:34 INFO exec.ListSinkOperator: 0 finished. closing...
  311. 13/12/11 09:36:34 INFO exec.ListSinkOperator: 0 forwarded 0 rows
  312. 13/12/11 09:36:34 INFO ql.Driver: <PERFLOG method=releaseLocks>
  313. 13/12/11 09:36:34 INFO ql.Driver: </PERFLOG method=releaseLocks start=1386725794916 end=1386725794916 duration=0>
  314. hive>
复制代码
patagonia

论坛徽章:
2
2015年辞旧岁徽章 日期:2015-03-03 16:54:152015年迎新春徽章 日期:2015-03-04 09:55:28
发表于 2013-12-11 14:20 |显示全部楼层
不明白你的意思是？
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP