zhaopingzi 发表于 2013-12-11 09:36

hive,show table是不



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

13/12/11 09:36:31 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames= columnTypes= separator=[ nullstring=lastColumnTakesRest=false
13/12/11 09:36:31 INFO exec.ListSinkOperator: Initializing Self 0 OP
13/12/11 09:36:31 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.DelimitedJSONSerDe initialized with: columnNames=[] columnTypes=[] separator=[ nullstring=lastColumnTakesRest=false
13/12/11 09:36:31 INFO exec.ListSinkOperator: Operator 0 OP initialized
13/12/11 09:36:31 INFO exec.ListSinkOperator: Initialization Done 0 OP
13/12/11 09:36:31 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames= columnTypes= separator=[ nullstring=lastColumnTakesRest=false
13/12/11 09:36:31 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:, properties:null)
13/12/11 09:36:31 INFO ql.Driver: </PERFLOG method=compile start=1386725790603 end=1386725791575 duration=972>
13/12/11 09:36:31 INFO ql.Driver: <PERFLOG method=Driver.execute>
13/12/11 09:36:31 INFO ql.Driver: Starting command: show tables
13/12/11 09:36:31 INFO ql.Driver: </PERFLOG method=TimeToSubmit start=1386725790603 end=1386725791672 duration=1069>
13/12/11 09:36:31 INFO ql.Driver: <PERFLOG method=runTasks>
13/12/11 09:36:31 INFO ql.Driver: <PERFLOG method=task.DDL.Stage-0>
13/12/11 09:36:31 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
13/12/11 09:36:31 DEBUG conf.Configuration: java.io.IOException: config(config)
      at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:260)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getConf(HiveMetaStore.java:381)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:413)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:402)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
      at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
      at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
      at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
      at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
      at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
      at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1139)
      at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
      at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2236)
      at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:333)
      at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
      at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
      at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
      at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
      at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.validateConstraints value null fromjpox.properties with false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.autoCreateSchema value null fromjpox.properties with false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.cache.level2 value null fromjpox.properties with false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.ConnectionUserName value null fromjpox.properties with hadoop
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.connectionPoolingType value null fromjpox.properties with DBCP
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.fixedDatastore value null fromjpox.properties with true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.ConnectionDriverName value null fromjpox.properties with com.mysql.jdbc.Driver
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.validateColumns value null fromjpox.properties with false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.NonTransactionalRead value null fromjpox.properties with true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.validateTables value null fromjpox.properties with false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.rdbms.useLegacyNativeValueStrategy value null fromjpox.properties with true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.identifierFactory value null fromjpox.properties with datanucleus1
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.cache.level2.type value null fromjpox.properties with SOFT
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.plugin.pluginRegistryBundleCheck value null fromjpox.properties with LOG
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.ConnectionURL value null fromjpox.properties with jdbc:mysql://192.168.7.81:3306/hive?createDatabaseIfNotExist=true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.autoStartMechanismMode value null fromjpox.properties with checked
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.DetachAllOnCommit value null fromjpox.properties with true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.storeManagerType value null fromjpox.properties with rdbms
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding datanucleus.transactionIsolation value null fromjpox.properties with read-committed
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.PersistenceManagerFactoryClass value null fromjpox.properties with org.datanucleus.api.jdo.JDOPersistenceManagerFactory
13/12/11 09:36:31 DEBUG metastore.ObjectStore: Overriding javax.jdo.option.Multithreaded value null fromjpox.properties with true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.rdbms.useLegacyNativeValueStrategy = true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.autoStartMechanismMode = checked
13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.Multithreaded = true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.identifierFactory = datanucleus1
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.transactionIsolation = read-committed
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.validateTables = false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.ConnectionURL = jdbc:mysql://192.168.7.81:3306/hive?createDatabaseIfNotExist=true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.DetachAllOnCommit = true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.NonTransactionalRead = true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.fixedDatastore = true
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.validateConstraints = false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.ConnectionDriverName = com.mysql.jdbc.Driver
13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.option.ConnectionUserName = hadoop
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.validateColumns = false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.cache.level2 = false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.plugin.pluginRegistryBundleCheck = LOG
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.cache.level2.type = SOFT
13/12/11 09:36:31 DEBUG metastore.ObjectStore: javax.jdo.PersistenceManagerFactoryClass = org.datanucleus.api.jdo.JDOPersistenceManagerFactory
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.autoCreateSchema = false
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.storeManagerType = rdbms
13/12/11 09:36:31 DEBUG metastore.ObjectStore: datanucleus.connectionPoolingType = DBCP
13/12/11 09:36:31 INFO metastore.ObjectStore: ObjectStore, initialize called
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
13/12/11 09:36:32 WARN bonecp.BoneCPConfig: Max Connections < 1. Setting to 20
13/12/11 09:36:33 DEBUG conf.Configuration: java.io.IOException: config()
      at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:227)
      at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:214)
      at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1091)
      at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:278)
      at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:304)
      at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:234)
      at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:209)
      at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
      at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
      at org.apache.hadoop.hive.metastore.RetryingRawStore.<init>(RetryingRawStore.java:64)
      at org.apache.hadoop.hive.metastore.RetryingRawStore.getProxy(RetryingRawStore.java:73)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:415)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:402)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
      at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
      at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
      at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
      at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
      at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
      at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1139)
      at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
      at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2236)
      at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:333)
      at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
      at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
      at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
      at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
      at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

13/12/11 09:36:33 DEBUG conf.Configuration: java.io.IOException: config()
      at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:227)
      at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:214)
      at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:330)
      at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:1125)
      at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1092)
      at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:278)
      at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:304)
      at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:234)
      at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:209)
      at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
      at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
      at org.apache.hadoop.hive.metastore.RetryingRawStore.<init>(RetryingRawStore.java:64)
      at org.apache.hadoop.hive.metastore.RetryingRawStore.getProxy(RetryingRawStore.java:73)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:415)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:402)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
      at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
      at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
      at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
      at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
      at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
      at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1139)
      at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
      at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2236)
      at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:333)
      at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
      at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
      at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
      at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
      at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

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"
13/12/11 09:36:33 INFO metastore.ObjectStore: Initialized ObjectStore
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
      at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1143)
      at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
      at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2236)
      at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:333)
      at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
      at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
      at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
      at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
      at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
      at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1212)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
      at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
      at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
      at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1139)
      ... 20 more
Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
      at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
      ... 25 more
Caused by: MetaException(message:Version information not found in metastore. )
      at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:5638)
      at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:5622)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.hive.metastore.RetryingRawStore.invoke(RetryingRawStore.java:124)
      at com.sun.proxy.$Proxy10.verifySchema(Unknown Source)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:403)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
      at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
      at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
      ... 30 more

13/12/11 09:36:34 INFO ql.Driver: </PERFLOG method=task.DDL.Stage-0 start=1386725791672 end=1386725794913 duration=3241>
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
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
13/12/11 09:36:34 INFO ql.Driver: </PERFLOG method=Driver.execute start=1386725791576 end=1386725794913 duration=3337>
13/12/11 09:36:34 INFO ql.Driver: <PERFLOG method=releaseLocks>
13/12/11 09:36:34 INFO ql.Driver: </PERFLOG method=releaseLocks start=1386725794913 end=1386725794913 duration=0>
13/12/11 09:36:34 INFO exec.ListSinkOperator: 0 finished. closing...
13/12/11 09:36:34 INFO exec.ListSinkOperator: 0 forwarded 0 rows
13/12/11 09:36:34 INFO ql.Driver: <PERFLOG method=releaseLocks>
13/12/11 09:36:34 INFO ql.Driver: </PERFLOG method=releaseLocks start=1386725794916 end=1386725794916 duration=0>
hive>

patagonia 发表于 2013-12-11 14:20

不明白你的意思是?
页: [1]
查看完整版本: hive,show table是不