hive 使用oracle作为元数据库报错

Question

14/04/24 04:30:02 INFO hive.metastore: Trying to connect to metastore with URI thrift://192.168.10.237:9083
14/04/24 04:30:02 WARN hive.metastore: Failed to connect to the MetaStore Server...
org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused

Answer 1

  > show tables;
14/04/24 04:30:02 INFO ql.Driver: <PERFLOG method=Driver.run>
14/04/24 04:30:02 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
14/04/24 04:30:02 INFO ql.Driver: <PERFLOG method=compile>
14/04/24 04:30:02 DEBUG parse.VariableSubstitution: Substitution is on: show tables
14/04/24 04:30:02 INFO parse.ParseDriver: Parsing command: show tables
14/04/24 04:30:02 INFO parse.ParseDriver: Parse Completed
14/04/24 04:30:02 INFO ql.Driver: Semantic Analysis Completed
14/04/24 04:30:02 DEBUG conf.Configuration: java.io.IOException: config(config)
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:226)
at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:184)
at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:195)
at org.apache.hadoop.hive.ql.exec.FetchTask.initialize(FetchTask.java:68)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:471)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:893)
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:412)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)14/04/24 04:30:02 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[tab_name] columnTypes=[string] separator=[[B@16614e7] nullstring=  lastColumnTakesRest=false
14/04/24 04:30:02 INFO exec.ListSinkOperator: Initializing Self 0 OP
14/04/24 04:30:02 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.DelimitedJSONSerDe initialized with: columnNames=[] columnTypes=[] separator=[[B@1b0bdc8] nullstring=  lastColumnTakesRest=false
14/04/24 04:30:02 INFO exec.ListSinkOperator: Operator 0 OP initialized
14/04/24 04:30:02 INFO exec.ListSinkOperator: Initialization Done 0 OP
14/04/24 04:30:02 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[tab_name] columnTypes=[string] separator=[[B@7bc899] nullstring=  lastColumnTakesRest=false
14/04/24 04:30:02 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer)], properties:null)
14/04/24 04:30:02 INFO ql.Driver: </PERFLOG method=compile start=1398339002071 end=1398339002248 duration=177>
14/04/24 04:30:02 INFO ql.Driver: <PERFLOG method=Driver.execute>
14/04/24 04:30:02 INFO ql.Driver: Starting command: show tables
14/04/24 04:30:02 INFO ql.Driver: </PERFLOG method=TimeToSubmit start=1398339002071 end=1398339002277 duration=206>
14/04/24 04:30:02 INFO hive.metastore: Trying to connect to metastore with URI thrift://192.168.10.237:9083
14/04/24 04:30:02 WARN hive.metastore: Failed to connect to the MetaStore Server...