Member since
03-14-2016
4721
Posts
1111
Kudos Received
874
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 2825 | 04-27-2020 03:48 AM | |
| 5479 | 04-26-2020 06:18 PM | |
| 4661 | 04-26-2020 06:05 PM | |
| 3702 | 04-13-2020 08:53 PM | |
| 5604 | 03-31-2020 02:10 AM |
08-21-2019
12:40 AM
@Manoj690 This is a completely different error ... Please open a separate Topic for detailed discussion and close this Thread. --require_secure_transport=ON Caused by: java.sql.SQLException: Connections using insecure transport are prohibited while --require_secure_transport=ON.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) https://mysqlserverteam.com/restricting-connections-to-secure-transport/
... View more
08-20-2019
10:42 PM
1 Kudo
@jsensharma There is a option like postgresql on MariaDB what you said. https://mariadb.com/kb/en/library/sql-mode/#sql_mode-values So, I setted sql_mode option in my.cnf like this and restarted MariaDB, hive-metastore and hive-server2. [mysqld]
...
sql_mode=NO_BACKSLASH_ESCAPES
... Than it showed me different exception again. I was sure query what hive ran was fine when I watched run query. Because this query already conciderated backslash escape character. So I removed sql_mode option and restarted MariaDB, hive-metastore and hive-server2 again. Than it didn't show any exception anymore. I don't have any idea what is different. Anyway this problem was gone and my hive-client has connected my MariaDB well. Caused by: java.sql.SQLException: Incorrect arguments to ESCAPE
Query is: SELECT A0.TBL_NAME AS NUCORDER0 FROM TBLS A0 LEFT OUTER JOIN DBS B0 ON A0.DB_ID = B0.DB_ID WHERE B0.`NAME` = ? AND LOWER(A0.TBL_NAME) LIKE '_%' ESCAPE '\\' ORDER BY NUCORDER0, parameters ['default']
java thread: pool-5-thread-2
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
... 37 more
... View more
08-20-2019
03:25 AM
1 Kudo
Hi, We don't share personal information like contacts, As you are facing Ambari Server issue and Agents issue is resolved, Please open a new question for Ambari Server, Also, check the Ambari Server logs you see some exceptions, attach those exceptions.
... View more
08-19-2019
11:05 AM
@jsensharma, Thank you very much for your prompt reply and clear answer. The reason for wanting to downgrade was to avoid a complete re-install (for logistical reasons). The version should have been 2.6.2.0 per spec request.
... View more
07-26-2019
09:10 PM
Think I found the problem, TLDR: firewalld (nodes running on centos7) was still running, when should be disabled on HDP clusters. From another community post: For Ambari to communicate during setup with the hosts it deploys to and manages, certain ports must be open and available. The easiest way to do this is to temporarily disable iptables, as follows: systemctl disable firewalld service firewalld stop So apparently iptables and firewalld need to be disabled across the cluster (supporting docs can be found here, I only disabled them on the Ambari installation node). After stopping these services across the cluster (I recommend using clush), was able to run the upload job without incident.
... View more
07-24-2019
12:57 AM
See comments / discussion of accepted answer for the steps that ultimately solved the problem.
... View more
07-12-2019
08:20 AM
this is the error
... View more
07-06-2019
08:59 PM
The above question and the entire response thread below was originally posted in the Community Help track. On Wed Jun 26 21:14 UTC 2019, a member of the HCC moderation staff moved it to the Cloud & Operations track. The Community Help Track is intended for questions about using the HCC site itself, not technical questions about using Ambari or upgrading HDP.
... View more
07-06-2019
09:54 PM
The above question and the entire response thread below was originally posted in the Community Help track. On Sat Jul 6 21:53 UTC 2019, a member of the HCC moderation staff moved it to the Cloud & Operations track. The Community Help Track is intended for questions about using the HCC site itself, not technical questions about spark thrift servers.
... View more