[ANNOUNCE] Apache Hive 1.2.2 Released

2017-04-07 Thread Vaibhav Gumashta
The Apache Hive team is proud to announce the release of Apache Hive version 1.2.2. The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in distributed storage. Built on top of Apache Hadoop (TM), it provides, among others: * Tools to enable easy

Re: beeline connection to Hive using both Kerberos and LDAP with SSL

2017-04-07 Thread Gopal Vijayaraghavan
> Is there anyway one can enable both (Kerberos and LDAP with SSL) on Hive? I believe what you're looking for is Apache Knox SSO. And for LDAP users, Apache Ranger user-sync handles auto-configuration. That is how SSL+LDAP+JDBC works in the HD Cloud gateway [1]. There might be a similar soluti

beeline connection to Hive using both Kerberos and LDAP with SSL

2017-04-07 Thread Mich Talebzadeh
Hi, The Hive on CDH 5.9 uses Kerberos security mechanism. We have an application that can connect to Impala with LDAP user/password and SSL. The problem is that Impala functionality is limited so the command sent via application to impala do not work. The problem is that the application does no

RE: Is it possible to use LOAD DATA INPATH with a PARTITIONED, STORED AS PARQUET table?

2017-04-07 Thread Ryan Harris
“I'm assuming …we'd have to organize the input Parquet files into subdirectories where each subdirectory contains data just for the given 'date'” Well, no… Given that you are doing CREATE TABLE and not CREATE EXTERNAL TABLE, you are creating a hive managed table….if hive is managing the table,

Re: Is it possible to use LOAD DATA INPATH with a PARTITIONED, STORED AS PARQUET table?

2017-04-07 Thread Furcy Pin
Hi Dmitry, I believe what you are referring to is similar to what the MSCK REPAIR TABLE command does in Hive: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-RecoverPartitions(MSCKREPAIRTABLE) Simply put: if you define a partitioned Hive table via a CREATE st