Member since
07-17-2017
143
Posts
16
Kudos Received
17
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1466 | 07-03-2019 02:49 AM | |
1659 | 04-22-2019 03:13 PM | |
1390 | 01-30-2019 10:21 AM | |
8050 | 07-25-2018 09:45 AM | |
7154 | 05-31-2018 10:21 AM |
04-17-2018
06:03 PM
Thanks for the reply Tim It was CDH 5.12.0 and it was working great on the same servers.. I'll share the CPU info of those nodes ASAS.
... View more
04-17-2018
04:08 PM
Sorry for the delay. Hmm, now I have doubt in your backend application! can you share the code used for read and browse your select query results..
... View more
04-17-2018
04:04 PM
1 Kudo
Hi @messenjah00, Can you share with us the proyecto1 table schema? I think you must use PARTITIONED BY in the create statement.
... View more
04-17-2018
03:53 PM
Hi, After I upgraded the cluster successfully to the last releases CM 5.14.0 / CDH 5.14.2, I have been faced to this problem in 6 of my nodes, suddenly in the first queries the impala deamon get stopped and the query cancelled and give the error messages below: Impala-shell: Cancelled due to unreachable impalad(s): node1.example.com:22000 ODBC: Status: RPC Error: Client for node5.example.com:22000 hit an unexpected exception: Unknown: Interrupted system call, type: N6apache6thrift9transport19TTransportExceptionE, rpc: N6impala19TTransmitDataResultE, send: done Impala Deamon log file: CancelQueryFInstances query_id= 3423055f3fda78a:a2446bea00000000 failed to connect to node2.example.com:22000 :Couldn't open transport for node2.example.com:22000 (connect() failed: Connection refused) Statestore log file: I0413 20:07:01.767758 64122 statestore.cc:729] Unable to send heartbeat message to subscriber impalad@node5.exaple.com:22000, received error: Couldn't open transport for node5.exaple.com:23000 (connect() failed: Connection refused) When I looking for the issue source I have found this crash message in the Impala Daemon logs: #
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGILL (0x4) at pc=0x0000000000d863e5, pid=13065, tid=0x00007efc499cf700
#
# JRE version: Java(TM) SE Runtime Environment (8.0_144-b01) (build 1.8.0_144-b01)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.144-b01 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [impalad+0x9863e5] impala::HdfsScanNodeBase::StopAndFinalizeCounters()+0x965
#
# Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again
#
# An error report file with more information is saved as:
# /var/run/cloudera-scm-agent/process/13339-impala-IMPALAD/hs_err_pid13065.log
#
# If you would like to submit a bug report, please visit:
# http://bugreport.java.com/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
# We have Centos OS v6.9 in the 6 servers, I tried to upgrade/downgrade to a several centos 6.9 kernel releases and jdk versions but no result, Here is the releases used: Centos 6.9 kernel: 2.6.32-696.23.1.el6.x86_64 2.6.32-696.16.1.el6.x86_64 2.6.32-696.13.2.el6.x86_64 2.6.32-642.15.1.el6.x86_64 2.6.32-642.11.1.el6.x86_64 JDK: jdk.1.8.0_144 jdk.1.8.0_121 Remark: The 6 nodes are the only nodes that does not support SSE4_2. Thanks in advance.
... View more
Labels:
04-05-2018
07:54 AM
Hmm, strange! Let me propose a temporary solution, in your select query try always to fill the 5 th by a null value or write the 5th column name twice and just adapt your get method.. SELECT a,b,c,d,null,e,f,g,h,i,j,k,l FROM typetest;
or
SELECT a,b,c,d,e,e,f,g,h,i,j,k,l FROM typetest; Lets me know if it doesn't work.
... View more
04-05-2018
07:35 AM
Hi @GopinathS You are welcome man, It's okay. You can work on them before the upload by removing the authentification code lines and replacing your domains/IPs.. else try to read it and if you find a abnormal, WARN or ERROR message try to share it here. Good luck.
... View more
04-03-2018
03:32 AM
Hi @GopinathS, You are welcome. Try to use a website like this one Upload files for free nd share the links..
... View more
04-02-2018
07:30 AM
ok, so try to active the Impala ODBC driver log also active the unixODBC log and rerun the same test then send to me the two log files to have a clear vision on this issue. To active impala odbc log, go to /opt/cloudera/impalaodbc/lib/64/cloudera.impalaodbc.ini and set this params: LogLevel=6
LogPath=[your_log_path] To active unixODBC go to /opt/cloudera/impalaodbc/Setup/odbcinst.ini and add this two line: Trace=Yes
TraceFile=[your_log_path]
... View more
04-02-2018
05:43 AM
Go in odbc.ini and set this param to 1 UseNativeQuery=1 Also try to use columns names in select: Select col1, col2, ... From typetest;
... View more
04-02-2018
01:59 AM
Hi @GopinathS You are welcome man, Do you work with CDH Impala ? if yes which release please ? Give me the query that you run. Also if it's possible try to active the odbc log and give us the whole logging file.
... View more