This is definitely a bug. Thanks for the clear report and reproduction. It's not IMPALA-7957 but is somewhat related. This is new to us so I filed https://issues.apache.org/jira/browse/IMPALA-10182 to track it.   It looks like it can only happen when you have a UNION ALL, plus subqueries where the same column appears twice in the select list, plus NULL values in those  columns.   You can work around the issue by removing the duplicated entries in the subquery select list. E.g. the following query is equivalent and returns the expected results.   SELECT MIN(t_53.c_41) c_41, CAST(NULL AS DOUBLE) c_43, CAST(NULL AS BIGINT) c_44, t_53.c2 c2, t_53.c2 c3s0, t_53.c4 c4, t_53.c4 c5s0 FROM ( SELECT t.productsubcategorykey c_41, t.productline c2, t.productsubcategorykey c4 FROM as_adventure.t1 t WHERE true GROUP BY 2, 3 ) t_53 GROUP BY 4, 5, 6, 7 UNION ALL SELECT MIN(t_53.c_41) c_41, CAST(NULL AS DOUBLE) c_43, CAST(NULL AS BIGINT) c_44, t_53.c2 c2, t_53.c2 c3s0, t_53.c5s0 c4, t_53.c5s0 c5s0 FROM ( SELECT t.productsubcategorykey c_41, t.productline c2, t.productsubcategorykey c5s0 FROM as_adventure.t1 t WHERE true GROUP BY 2, 3) t_53 GROUP BY 4, 5, 6, 7;   ... View more

Hello @Yuriy_but ,   it is good to hear you found the solution and it works for you now!   Best regards: Ferenc ... View more

@AJM  The valid license means the Enterprise features availability. If your subscription ends then your Software suit will work but: 1. You will not be able to use some explicit features[1] in that as stated here.  LDAP and SAML authentication Configuration history Alerts delivered as SNMP traps and custom alert scripts Backup and disaster recovery Operational reports Cloudera Navigator Commands such as Rolling Restart, History and Rollback, and Send Diagnostic Data Cluster Utilization Reports Role Based Access Control and Cluster-specific Roles 2. You will not be able to avail Cloudera Support on that product.    [1] https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_ag_licenses.html#cmug_topic_13_7 ... View more

@P_Rat98  You need parquet tools to read parquet files from command line. There is no method to view parquet in nifi.   https://pypi.org/project/parquet-tools/     ... View more

Hello @Atradius ,   thank you for reaching out to the Community with your issue of having both NameNodes down.   Do you see in your NN log entries like JvmPauseMonitor saying "Detected pause in JVM or host machine" and a value larger than 1000ms, please? It can be an indication that your service is running out of heap. If it is the NameNode, the short-term solution is to increase the heap and restart the service. A long term solution is to identify why did you run out of heap? E.g. do you face with small files issue? Please read article [1] about how to tackle this.   Losing quorum might be caused by ZK service issue, when the ZK is not in quorum. Please check the ZK logs as well.   Please let us know if you need more input to progress with your investigation.   Best regards: Ferenc   [1] https://blog.cloudera.com/small-files-big-foils-addressing-the-associated-metadata-and-application-challenges/ ... View more

Hello @Aswinnxp ,   thank you for letting us know that after registration to the Support Portal you have difficulties raising a case.   Do you have a valid Cloudera Subscription, please? It will be required to be able to raise a Support Case.   Once you have Cloudera Subscription, the steps to take to register to the portal are: 1. Register at: https://sso.cloudera.com/register.html  You will be sent an email with a validation link.  2. Please click this link to complete your registration. 3. Set your password 4. Login at https://sso.cloudera.com.   I understand that you've done these steps.   Until you will be reached out following your registration, we can do one more thing: Do you have a colleague that has working portal access and can raise a case, please? In this case please raise a case to get further assistance on your access.   Thank you: Ferenc ... View more

Hello @tresk ,   thank you for reaching out to the Community.   Wondering if this is the doc you were looking for: "The JDBC connection string for connecting to a remote Hive client requires a host, port, and Hive database name. You can optionally specify a transport type and authentication." jdbc:hive2://<host>:<port>/<dbName>;<sessionConfs>?<hiveConfs>#<hiveVars>   Please let us know!   Thank you: Ferenc ... View more

Hello @Suyog1981 ,   thank you for reaching out to Community. I understand that your issue is: After upgrading from CDH5.12 to CDH6.3.3. MR2 job that is connecting to HBase is failing and it seems to be that the runtime is still pointing to CDH5.12.   Can you please check if any of the links under /etc/alternatives or /var/lib/alternatives is still pointing to CDH5.12 paths on the node where the container of the MR job is failing? E.g. use: grep CDH-5.12 * | awk -F ':' '{print $1}'   Thank you: Ferenc ... View more