Member since
07-07-2020
70
Posts
4
Kudos Received
4
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
511 | 06-13-2022 10:24 PM | |
1945 | 06-09-2022 09:56 PM | |
742 | 10-12-2021 07:13 AM | |
1376 | 09-22-2021 10:54 PM |
03-21-2023
12:01 AM
Hello , - Please share the complete impala-shell command that you are using? - Is there any load balancer configured for impala? Thanks
... View more
07-19-2022
09:31 PM
For the workflows that were created on Hue, you can follow the next steps to export/import the workflows:
>To export:
Go to Documents> Select the workflow(s)> Select the button with three dots and select the Export option
>To import:
Go to Documents> Select the button with three dots and select the Import option.
... View more
06-26-2022
06:16 PM
As upsert is not SQL-92 syntax, the Impala JDBC driver does not currently support it. However, we are currently testing a newer version of the JDBC driver and hope to support upsert in the near future. For the time being, please break these statements into a combination of insert and update statements.
... View more
06-23-2022
03:56 AM
For a permanent fix, you need to install the python version 2.7.5.
... View more
06-22-2022
07:51 AM
Yes, you need to switch to venv everytime or you need to reinstall python with the 2.7.5 version.
... View more
06-22-2022
07:34 AM
You can try the below steps in edge node B virtualenv venv -p python2 cd venv source bin/activate (venv) impala-shell
... View more
06-22-2022
07:31 AM
Hello Syed, Yes, the impala is compatible with Python version 2.7.5.
... View more
06-13-2022
10:24 PM
Oozie Email Action supports attachments of HDFS files. Because standard output files are written as local files, you need to copy them to HDFS first, then specify the path in the <attachment> tag of the email action. <workflow-app name="[WF-DEF-NAME]" xmlns="uri:oozie:workflow:0.1"> ... <action name="[NODE-NAME]"> <email xmlns="uri:oozie:email-action:0.2"> <to>[COMMA-SEPARATED-TO-ADDRESSES]</to> <cc>[COMMA-SEPARATED-CC-ADDRESSES]</cc> <!-- cc is optional --> <subject>[SUBJECT]</subject> <body>[BODY]</body> <content_type>[CONTENT-TYPE]</content_type> <!-- content_type is optional --> <attachment>[COMMA-SEPARATED-HDFS-FILE-PATHS]</attachment> <!-- attachment is optional --> </email> <ok to="[NODE-NAME]"/> <error to="[NODE-NAME]"/> </action> ... </workflow-app>
... View more
06-09-2022
09:56 PM
Hello Team, We have tested the java code internally and it worked fine for us. ClouderaJDBC version:- 2.6.27.1032 Java code:- ======== import java.sql.*; import java.math.*; public class test{ public static void main(String args[]){ try{ Class.forName("com.cloudera.impala.jdbc41.Driver"); Connection con=DriverManager.getConnection("jdbc:impala://<<hostname>> :21050;UseNativeQuery=1"); String sql = "upsert into user_info(id, name, address, email, insert_time) values (?,?,?,?,?)"; PreparedStatement statement = con.prepareStatement(sql); statement.setInt(1, 102); statement.setString(2, "Peter"); statement.setString(3, "New York"); statement.setString(4, "John@xyz.com"); statement.setTimestamp(5, java.sql.Timestamp.valueOf(java.time.LocalDateTime.now())); statement.addBatch(); statement.executeBatch(); statement.close(); con.close(); } catch(Exception e){ System.out.println(e); } } } Please let us know if it helps.
... View more
06-09-2022
12:29 AM
Please elaborate a little more on the issue:- Also please share the steps you are performing and share the table DDL for the same.
... View more