Basic the Xquery does not return anything (null return) ... View more

Thanks. We have decided to introduce Priority attribute & use the corresponding prioritizer for the connection. ... View more

Hi @Magudeswaran , I can rewrite the query using sub-queries, but I have the same error: select count(*) as num_all_changes from ( select s.cod_pers, count(*) as num_changes from ( select t.cod_pers, t.cod_address, count(*) as num_address from be_prd_prt.test_case as t group by t.cod_pers, t.cod_address ) as s group by s.cod_pers having count(*)>1 ) as gg ; +------------------+ | num_all_changes | +------------------+ | 63 | | 58 | | 64 | | 59 | +------------------+ 4 rows selected (18.077 seconds)   As you can see, always 4 rows... ... View more

Hi @Magudeswaran    Ambari server uses appropriate database base connector which is located under /user/share/java/*<databasename>.jar  This same connector jar is used to connect to any external or internal database. It needs to be mentioned using ambari-server --jdbc * command. Refer documentation for exact command. Issue could be due to the connector jar that is configured for ambari to use. For eg. Ambari is configured to use postgres but you are trying to connect to Mariadb and since it doesn't has the proper jar configured, it won't connect and you will face issue.   Let me know if this resolves your issue. Else please share the screen shot and error logs to check further.       ... View more