Member since
09-19-2020
46
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2177 | 07-13-2021 12:09 AM |
06-22-2021
02:54 AM
Hi, can you please advise on the steps to build the workflows on Hue? Thanks, Roshan
... View more
06-15-2021
05:30 AM
Hello Alex, I have checked the port. netstat -tulpn | grep impalad tcp 0 0 <IP>:27000 0.0.0.0:* LISTEN 23290/impalad tcp 0 0 0.0.0.0:25000 0.0.0.0:* LISTEN 23290/impalad tcp6 0 0 :::22000 :::* LISTEN 23290/impalad tcp6 0 0 :::23000 :::* LISTEN 23290/impalad the port is 23290 I checked on Cloudera whether there is SSL for impala. Only Ranger configured. [root@rb-hadoop-02 admin]# impala-shell -i <IP>:23290 --user=hive --ssl Starting Impala Shell without Kerberos authentication SSL is enabled. Impala server certificates will NOT be verified (set --ca_cert to change) No handlers could be found for logger "thrift.transport.TSSLSocket" Error connecting: TTransportException, Could not connect to <IP>:23290: [Errno 111] Connection refused *********************************************************************************** Welcome to the Impala shell. (Impala Shell v3.4.0-SNAPSHOT (134517e) built on Sat Dec 12 11:15:02 UTC 2020) After running a query, type SUMMARY to see a summary of where time was spent. *********************************************************************************** [Not connected] > exit; Regards, Roshan
... View more
06-13-2021
07:19 PM
Hi, thanks for the update. Please find below details: impalad version 3.4.0-SNAPSHOT RELEASE (build 134517e42b7b6085e758195465f956f431e0e575) Built on Sat Dec 12 11:15:02 UTC 2020 Version: Cloudera Enterprise 7.1.3 (#4999720 built by jenkins on 20200805-1701 git: fa596184790377f07ba80e9cd4da8b875237939c) Java VM Name: OpenJDK 64-Bit Server VM Java Version: 11.0.10 Thanks, Roshan
... View more
06-13-2021
07:17 PM
Hi, thanks for the update. Please find below details: impalad version 3.4.0-SNAPSHOT RELEASE (build 134517e42b7b6085e758195465f956f431e0e575) Built on Sat Dec 12 11:15:02 UTC 2020 Version: Cloudera Enterprise 7.1.3 (#4999720 built by jenkins on 20200805-1701 git: fa596184790377f07ba80e9cd4da8b875237939c) Java VM Name: OpenJDK 64-Bit Server VM Java Version: 11.0.10 Thanks, Roshan
... View more
06-12-2021
07:42 AM
Hello Team, is there a way we can schedule a sql statement in Impala (hue)? For example I wish to schedule delete of a table. delete cdr.tab1; Thanks, Roshan
... View more
Labels:
- Labels:
-
Apache Impala
06-11-2021
05:11 AM
Hello Team, can you please help me with the connection to impala? [root@rb-hadoop-02 admin]# impala-shell -i <HUE_IP>:27000 --user=hive Starting Impala Shell without Kerberos authentication Opened TCP connection to 10.10.104.106:27000 Socket error 32: [Errno 32] Broken pipe *********************************************************************************** Welcome to the Impala shell. (Impala Shell v3.4.0-SNAPSHOT (134517e) built on Sat Dec 12 11:15:02 UTC 2020) Press TAB twice to see a list of available commands. *********************************************************************************** [Not connected] > show dbs; Connection lost, reconnecting... Opened TCP connection to 10.10.104.106:27000 Socket error 32: [Errno 32] Broken pipe Query: show dbs Not connected (use CONNECT to establish a connection) [Not connected] > Thanks, Roshan
... View more
Labels:
- Labels:
-
Apache Impala
-
Cloudera Manager
- « Previous
- Next »