Hi there,
we had a cluster with 6 nodes(41,42,43,44,45,46) in it one is name node(42)
and other 5 are data nodes. on one data node (41) we installed HIVE
completely no other service is installed on it. I want to use IMPALA now on
HIVE tables. on namenode(42) and other 4 datanodes(43,44,45,46) IMPALA
service is there but there is no SERVICE on HIVE data node(41) due to that
i am able to see the databases of HIVE that i created but i am unable to
see the tables what are containing in those databases. when typing the
command "Show Tables" from IMPALA shell it is throwing an error as
mentioned below. can anyone suggest what to do.
(Build version: Impala v0.6 (720f93c) built on Sat Feb 23 18:52:43 PST 2013)
[Not connected] > connect localhost
Connected to localhost:21000
[localhost:21000] > show databases;
Query: show databases
Query finished, fetching results ...
bcllf
default
Returned 4 row(s) in 0.01s
[localhost:21000] > use default;
Query: use default
Query finished, fetching results ...
Returned 0 row(s) in 0.00s
[localhost:21000] > show tables;
Query: show tables
ERROR: com.google.common.util.concurrent.UncheckedExecutionException:
java.lang.IllegalStateException: MetaException(message:Got exception:
org.apache.thrift.transport.TTransportException java.net.SocketException:
Broken pipe)
at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2234)
at com.google.common.cache.LocalCache.get(LocalCache.java:3965)
at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3969)
at
com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4829)
at
com.cloudera.impala.catalog.Catalog$LazyDbMap.get(Catalog.java:132)
at com.cloudera.impala.catalog.Catalog.getDb(Catalog.java:269)
at
com.cloudera.impala.catalog.Catalog.getTableNames(Catalog.java:287)
at
com.cloudera.impala.service.Frontend.getTableNames(Frontend.java:161)
at
com.cloudera.impala.service.JniFrontend.getTableNames(JniFrontend.java:136)
Caused by: java.lang.IllegalStateException: MetaException(message:Got
exception: org.apache.thrift.transport.TTransportException
java.net.SocketException: Broken pipe)
at com.cloudera.impala.catalog.Db.loadDb(Db.java:240)
at
com.cloudera.impala.catalog.Catalog$LazyDbMap.loadDb(Catalog.java:163)
at
com.cloudera.impala.catalog.Catalog$LazyDbMap.access$000(Catalog.java:87)
at
com.cloudera.impala.catalog.Catalog$LazyDbMap$1.load(Catalog.java:93)
at
com.cloudera.impala.catalog.Catalog$LazyDbMap$1.load(Catalog.java:91)
at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3568)
at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2350)
at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2313)
at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2228)
... 8 more
Caused by: MetaException(message:Got exception:
org.apache.thrift.transport.TTransportException java.net.SocketException:
Broken pipe)
at
org.apache.hadoop.hive.metastore.MetaStoreUtils.logAndThrowMetaException(MetaStoreUtils.java:833)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getAllTables(HiveMetaStoreClient.java:829)
at com.cloudera.impala.catalog.Db.(Db.java:230)
... 16 more
thanks for the help
