FAQ
What version of Impala are you running? Could you provide us with more of
the log file?

Skye

On Fri, Mar 8, 2013 at 10:08 AM, Aaron T. Myers wrote:

Forwarding this over to impala-user@, which should be able to help you
out.


--
Aaron T. Myers
Software Engineer, Cloudera

On Thu, Mar 7, 2013 at 11:35 PM, wrote:

Hi All,

i have 2 node cluster,in both the systems impalad is running
successfully. from one node i run the query using impala-shell.

in impala shell it is showing results and suddenly stops printing the
results and blocked because second node is giving error

E0308 08:29:15.963053 28519 impala-server.cc:1301] unknown query id:
a8263f748d794d10:**b9b5d81323298105

Please help me,if i am missing any configuration

Thanks in Advance,

--


Search Discussions

  • Anilarava at Mar 13, 2013 at 3:30 am
    Hi skye wanderman,

    i am using impala 0.5-1 and cdh4 version 4.0.1.

    *I am seeing below messages in my master node impalad*.

    *i am running impala-shell in masternode it is showing data in impala-shell
    and suddenly stops printing the data. *

    13/03/12 23:12:28 INFO HiveMetaStore.audit: ugi=hduser
    ip=unknown-ip-addr cmd=get_table : db=metastorecdh4 tbl=sales
    13/03/12 23:12:28 INFO metastore.HiveMetaStore: 1: get_partitions :
    db=metastore
    cdh4 tbl=sales
    13/03/12 23:12:28 INFO HiveMetaStore.audit: ugi=hduser
    ip=unknown-ip-addr cmd=get_partitions : db=metastorecdh4 tbl=sales
    13/03/12 23:12:28 INFO DataNucleus.Datastore: The class
    "org.apache.hadoop.hive.
    *metastore.model.MFieldSchema" is tagged as "embedded-only" so does not
    have its own datastore table*.
    13/03/12 23:12:28 INFO DataNucleus.Datastore: The class
    "org.apache.hadoop.hive.
    metastore.model.MOrder" is tagged as "*embedded-only*" so does not have its
    own datastore table.
    13/03/12 23:12:28 INFO DataNucleus.Persistence: Managing Persistence of
    Class
    :
    org.apache.hadoop.hive.metastore.model.MPartition [Table : `PARTITIONS`,
    InheritanceStrategy : new-table]
    1*3/03/12 23:12:28 INFO DataNucleus.Persistence: Managing Persistence of
    Field :*
    org.apache.hadoop.hive.metastore.model.MPartition.parameters [Table :
    `PARTITION _PARAMS`]
    13/03/12 23:12:28 INFO DataNucleus.Persistence: Managing Persistence of
    Field
    :
    org.apache.hadoop.hive.metastore.model.MPartition.values [Table :
    `PARTITION_KEY_VALS`]
    13/03/12 23:12:28 INFO service.Frontend: create plan
    13/03/12 23:12:28 INFO planner.Planner: *create single-node plan
    *13/03/12 23:12:28 INFO planner.Planner: create plan fragments
    13/03/12 23:12:28 INFO planner.Planner: finalize plan fragments
    13/03/12 23:12:28 INFO planner.HdfsScanNode: collecting partitions for
    table sales
    13/03/12 23:12:28 INFO service.Frontend: get scan range locations
    13/03/12 23:12:28 INFO catalog.HdfsTable: loaded partiton
    PartitionBlockMetadata{#blocks=1, #filenames=1, totalStringLen=116}
    13/03/12 23:12:29 INFO hdfs.BlockStorageLocationUtil: *Failed to connect to
    datanode firsthostdatanode:50020
    *13/03/12 23:12:29 INFO hdfs.BlockStorageLocationUtil: *Failed to connect
    to datanode secondhostdatanode:50020
    *13/03/12 23:12:29 INFO catalog.HdfsTable: loaded disk ids for
    PartitionBlockMeta data{#blocks=1, #filenames=1, totalStringLen=116}
    13/03/12 23:12:29 INFO catalog.HdfsTable: block metadata cache:
    CacheStats{hitCount=0, missCount=1, loadSuccessCount=1,
    loadExceptionCount=0, totalLoadTime=168128096, evictionCount=0}
    13/03/12 23:12:29 INFO service.Frontend: create result set metadata
    13/03/12 23:12:29 INFO service.JniFrontend: Plan Fragment 0
    UNPARTITIONED
    EXCHANGE (1)
    TUPLE IDS: 0
    Plan Fragment 1
    RANDOM
    STREAM DATA SINK
    EXCHANGE ID: 1
    UNPARTITIONED
    SCAN HDFS table=metastorecdh4.sales #partitions=1 size=19.25MB (0)
    TUPLE IDS: 0


    *and in slave node i am seeing below excpetion*

    E0308 08:29:15.963053 28519 impala-server.cc:1301] unknown query id:
    a8263f748d794d10:**b9b5d81323298105


    *Final logs in impala-server*

    Hardware Supports:
    I0312 22:56:18.532546 20224 disk-info.cc:95] Disk Info:
    Num disks 1: sda
    I0312 22:56:18.532557 20224 webserver.cc:145] Starting webserver on all
    interfaces, port 25010
    I0312 22:56:18.532568 20224 webserver.cc:155] Document root: /usr/lib/impala
    I0312 22:56:18.533478 20224 webserver.cc:194] Webserver started
    I0312 22:56:18.534198 20258 state-store.cc:416] State-store entering
    heartbeat / update loop
    I0312 22:56:18.543666 20224 thrift-server.cc:340] ThriftServer
    'StateStoreService' started on port: 24000
    I0312 22:56:18.543725 20224 state-store.cc:324] StateStore listening on
    24000
    I0312 22:57:02.852763 20364 state-store.cc:213] Registered subscription
    (id: simple.scheduler, for: 127.0.0.1:23000) for 1 topics
    (impala_backend_service)
    I0312 22:57:02.852882 20364 state-store.cc:124] Registered service instance
    (id: impala_backend_service, for: firsthost(127.0.0.1):22000)
    I0312 22:57:02.852931 20364 state-store.cc:213] Registered subscription
    (id: impala.server, for: 127.0.0.1:23000) for 1 topics
    (impala_backend_service)
    I0312 23:06:08.597244 20258 state-store.cc:458] Unable to update client at
    firstnode:23000; received error No more data to read.
    I0312 23:06:09.597277 20258 state-store.cc:458] Unable to update client at
    secondnode:23000; received error write() send(): Broken pipe
    I0312 23:06:10.618155 20258 state-store.cc:439] Unable to update client at
    firsthost:23000; received error Couldn't open transport for
    HYDPCM308748D.ad.infosys.com:23000(connect() failed: Connection refused)
    I0312 23:06:13.607573 20258 state-store.cc:471] Subscriber at
    127.0.0.1:23000 has failed, and will be removed.
    I0312 23:06:13.607641 20258 state-store.cc:368] Remove subscription
    impala.server for 0 on impala_backend_service.
    I0312 23:06:13.607664 20258 state-store.cc:368] Remove subscription
    simple.scheduler for 0 on impala_backend_service.
    I0312 23:06:19.799046 20631 state-store.cc:213] Registered subscription
    (id: simple.scheduler, for: 127.0.0.1:23000) for 1 topics
    (impala_backend_service)
    I0312 23:06:19.799196 20631 state-store.cc:124] Registered service instance
    (id: impala_backend_service, for: firsthost 127.0.0.1):22000)
    I0312 23:06:19.799245 20631 state-store.cc:213] Registered subscription
    (id: impala.server, for: 127.0.0.1:23000) for 1 topics
    (impala_backend_service)
    I0312 23:06:38.038418 20767 state-store.cc:213] Registered subscription
    (id: simple.scheduler, for: 10.219.197.8:23000) for 1 topics
    (impala_backend_service)
    I0312 23:06:38.038933 20767 state-store.cc:124] Registered service instance
    (id: impala_backend_service, for: secondhost(ip):22000)
    I0312 23:06:38.039461 20767 state-store.cc:213] Registered subscription
    (id: impala.server, for: secondhost:23000) for 1 topics
    (impala_backend_service)
    I0312 23:07:02.208449 20770 state-store.cc:213] Registered subscription
    (id: simple.scheduler, for: thirdhost:23000) for 1 topics
    (impala_backend_service)
    I0312 23:07:02.209136 20770 state-store.cc:124] Registered service instance
    (id: impala_backend_service, for: thirdhost:22000)
    I0312 23:07:02.209635 20770 state-store.cc:213] Registered subscription
    (id: impala.server, for: thirdhost:23000) for 1 topics
    (impala_backend_service)
    I0312 23:32:01.761719 20258 state-store.cc:458] Unable to update client at
    firsthost:23000; received error No more data to read.

    please help me on this. i have been struck over here for last 1 week.

    Thanks,

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedMar 8, '13 at 7:58p
activeMar 13, '13 at 3:30a
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Anilarava: 1 post Skye Wanderman-Milne: 1 post

People

Translate

site design / logo © 2021 Grokbase