I am using HDP 2.4.0.7. I am trying to find the default values for the following properties for Phoenix/HBase: hbase.hconnection.threads.max phoenix.client.connection.max.allowed.connections Since these values have not been set, I believe it will use the default value. I want to know the default values. ... View more

Just wanted to understand if there is any functional difference on how sort and orderBy functions on DataFrame works. Can it be compared to total order sorting across all partitioner outputs or sorting on data within each partition and no guarantee of total order sorting ? Based on the clarifications, I would like to know the usage of both the functions. ... View more

I want to avoid setting auto-commit=true by default, thus I am not adding the required property in hbase-site.xml. However, I want to add auto commit property to the jdbc url so that I can get a connection with autocommit=true on need basis. I am not able to find how to add this property to connection url. I have a kerberized cluster and I an using the following url: jdbc:phoenix[:zk_quorum][:zk_port][:zk_hbase_path][:headless_keytab_file:principal] I also tried the following approach but it did not connect due to malformed url: jdbc:phoenix[:zk_quorum][:zk_port][:zk_hbase_path][:headless_keytab_file:principal][:AutoCommit=true] ... View more

I want to understand how the applicationId is generated when a job is submitted to Yarn. ... View more

As per this JIRA HIVE-11217, there was a bug in Hive where a CTAS statement having NULL in select clause throws IllegalArgumentException:Unknown primitive type VOID. The bug was fixed and patched in version 1.3.0 and 2.0.0 as per the JIRA and the solution was to use CAST to specify a type when having NULL in select clause. If I am using Hive 1.2.x and my CTAS select clause has "CAST(null as bigint)" will it still throw IllegalArgumentException:Unknown primitive type VOID ? ... View more