Hi, what about if you try to explicitly specify the list of columns, rather than "*"? Also, I am not sure if you read and write to the same table and partition is a good idea. Can you try to create a new table instead? Cheers Eric ... View more

Latest driver can be found here: https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-12.html Suggest you to try a few different versions to see if it is bug in the earlier versions. Thanks Eric ... View more

Thanks That's pretty clear now. Can you confirm the version of Impala JDBC driver you are using? Have you tried the latest version to see if the behaviour is the same? Cheers ... View more

Hi, Sorry, but your question is really not clear, as you are not giving context. You should have mentioned that you are using Impala JDBC driver. Secondly, sql1 returned lowercase "nickname", but sql2 returned with uppercase "nickName", which query you used setting LowerCaseResultSetColumnName and which one returned correct result? Please provide more information with context around your question, otherwise it is difficult to understand what you are really after. Cheers Eric ... View more

Sorry, but what's the issue here? What's the error? ... View more

That's odd, clearly CM tried to get info from "metastore" database, not "scm" database, based on the error message you shared. If you try to change the details in db.properties file, will you get different error message? Like change to wrong password, a database that does not exist? Just to confirm if we are looking at the right property file. Cheers Eric ... View more

Hi iamfromsky, To confirm, are you able to change your LB's setting to check less frequent to see if the number of error/warning will also reduce? However, based on my experience, the error produced by LB's tcp check normally is SASL related, not like "java.net.SocketException: Connection reset". It would be good to modify LB setting to confirm though. Cheers Eric ... View more

Hi @Cristian.fuentesd, 50010 is the DataNode port: remote=xxxxxxx.xxx.xx/xxx.xx.x.xxx:50010 Have you checked the DataNode log on host xxxxxxx.xxx.xx? (You probably want to mask your host names). Cheers Eric ... View more

Hi @dennisli, I think you messed your database up between CM's database vs HMS's database. CM_VERSION table should be under CM's database, not Hive's. What you showed in the list of tables under metastore is for Hive. You should update your database name for CM under /etc/cloudera-scm-server/db.properties. Cheers Eric ... View more