Thanks, i didn't realized i am not actually logged at the moment ... View more

Found the problem. It is mysql version mismatched. ... View more

@Manoj690 There is no need to close a thread after you have solved your issue. Simply mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.            ... View more

@Manoj690  Better approach will be to change the PORT in yarn config from 53 to something unused.   https://community.cloudera.com/t5/Community-Articles/YARN-REGISTRY-DNS-Port-Conflict-Issue/ta-p/249117 ... View more

When your first post titled "Ambari-server start error" was caught by the spam filter, you created a second post with the same content.   I approved one of them so we didn't have duplicate questions on the board.   I am unsure why your posts were flagged as spam.  Our Community Admins are still tuning the spam filter rules after merging into the Unified Cloudera Community.   Our moderators will get posts out of spam quarantine as quickly as we are able.  I apologize again for the inconvenience.   ... View more

@Manoj690  If Ambari Server is up and running now then can you mark this thread as closed.  The other threads regarding MySQL + Ambari connectivity are here: https://community.cloudera.com/t5/Support-Questions/ambari-server-problem-3/m-p/268500/highlight/false#M206233 https://community.cloudera.com/t5/Support-Questions/ambari-server-problem-2/m-p/268487#M206225 ... View more

Thanks a lot   finally ambari server started ... View more

@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

@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