Hi,
I have installed IMPALA in a 3 node cluster.
I am able to successfully start all the 3 impalad services & 1 statestored
service from Cloudera Manager.
But the issue that :
When I start Impala Shell and then execute refresh command then the data is
not reflected in Impala.
Please find below the logs for the same :
DATA NODE LOGS :
Refreshing catalog
INFO0201 01:00:44.353000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore] 5: Shutting down the object store...
INFO0201 01:00:44.354000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore.audit] ugi=impala ip=unknown-ip-addr cmd=Shutting down the object store...
INFO0201 01:00:44.354000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore] 5: Metastore shutdown complete.
INFO0201 01:00:44.354000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore.audit] ugi=impala ip=unknown-ip-addr cmd=Metastore shutdown complete.
INFO0201 01:00:44.459000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore] 5: get_all_databases
INFO0201 01:00:44.459000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore.audit] ugi=impala ip=unknown-ip-addr cmd=get_all_databases
INFO0201 01:00:44.460000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore] 5: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
INFO0201 01:00:44.462000 Thread-7 org.apache.hadoop.hive.metastore.ObjectStore] ObjectStore, initialize called
INFO0201 01:00:44.462000 Thread-7 org.apache.hadoop.hive.metastore.ObjectStore] Initialized ObjectStore
INFO0201 01:00:44.472000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore] 5: get_tables: db=default pat=*
INFO0201 01:00:44.472000 Thread-7 org.apache.hadoop.hive.metastore.HiveMetaStore.audit] ugi=impala ip=unknown-ip-addr cmd=get_tables: db=default pat=*
STATE-STORE-LOGS
Couldn't open transport for cldx-1001-901:23000(connect() failed: No route to host)
@ 0x50bbf1 (unknown)
@ 0x4d37b4 (unknown)
@ 0x4e5549 (unknown)
@ 0x57981b (unknown)
@ 0x3e250077f1 (unknown)
@ 0x3e24ce570d (unknown)
1:12:13.992 AM INFO state-store.cc:471
Subscriber at 192.35.35.170:23000 has failed, and will be removed.
1:12:13.992 AM INFO state-store.cc:368
Remove subscription impala.server for 588 on impala_backend_service.
1:12:13.992 AM INFO state-store.cc:368
Remove subscription simple.scheduler for 588 on impala_backend_service.
1:12:20.531 AM INFO state-store.cc:124
Registered service instance (id: impala_backend_service, for: cldx-1000-900(192.35.35.165):22000)
1:12:20.534 AM INFO state-store.cc:213
Registered subscription (id: impala.server, for: 192.35.35.165:23000) for 1 topics (impala_backend_service)
1:12:20.535 AM INFO state-store.cc:213
Registered subscription (id: simple.scheduler, for: 192.35.35.165:23000) for 1 topics (impala_backend_service)
1:12:20.992 AM INFO thrift-util.cc:53
TSocket::open() connect() <Host: cldx-1000-900 Port: 23000>No route to host
1:12:20.994 AM INFO status.cc:36
Couldn't open transport for cldx-1000-900:23000(connect() failed: No route to host)
@ 0x50bbf1 (unknown)
@ 0x4d37b4 (unknown)
@ 0x4e5549 (unknown)
@ 0x57981b (unknown)
@ 0x3e250077f1 (unknown)
@ 0x3e24ce570d (unknown)
1:12:20.994 AM INFO state-store.cc:471
Subscriber at 192.35.35.165:23000 has failed, and will be removed.
1:12:20.994 AM INFO state-store.cc:368
Remove subscription impala.server for 589 on impala_backend_service.
1:12:20.994 AM INFO state-store.cc:368
Remove subscription simple.scheduler for 589 on impala_backend_service.
1:12:23.424 AM INFO state-store.cc:124
Registered service instance (id: impala_backend_service, for: cldx-1001-901(192.35.35.170):22000)
1:12:23.425 AM INFO state-store.cc:213
Registered subscription (id: impala.server, for: 192.35.35.170:23000) for 1 topics (impala_backend_service)
1:12:23.426 AM INFO state-store.cc:213
Registered subscription (id: simple.scheduler, for: 192.35.35.170:23000) for 1 topics (impala_backend_service)
1:12:23.993 AM INFO thrift-util.cc:53
TSocket::open() connect() <Host: cldx-1001-901 Port: 23000>No route to host
1:12:23.994 AM INFO status.cc:36
Couldn't open transport for cldx-1001-901:23000(connect() failed: No route to host)
@ 0x50bbf1 (unknown)
@ 0x4d37b4 (unknown)
@ 0x4e5549 (unknown)
@ 0x57981b (unknown)
@ 0x3e250077f1 (unknown)
@ 0x3e24ce570d (unknown)
1:12:23.994 AM INFO state-store.cc:471
Subscriber at 192.35.35.170:23000 has failed, and will be removed.
1:12:23.995 AM INFO state-store.cc:368
Remove subscription impala.server for 590 on impala_backend_service.
1:12:23.995 AM INFO state-store.cc:368
Remove subscription simple.scheduler for 590 on impala_backend_service.
Best Regards,
Radhakrishnan Iyer