Hive-Hbase integration thorws "java.lang.ClassNotFoundException: NULL::character varying" (Postgres)

2016-11-14 Thread Anshuman Dwivedi
Hi Guys When doing hive to hbase integration, we have observed that current Apache Hive 2.x is not able to recognise 'NULL::character varying' (Variant data type of NULL in prostgres) properly and throws the java.lang.ClassNotFoundException exception. Exception: FAILED: RuntimeException

Re: s3a and hive

2016-11-14 Thread Jörn Franke
Is it a permission issue on the folder? > On 15 Nov 2016, at 06:28, Stephen Sprague wrote: > > so i figured i try and set hive.metastore.warehouse.dir=s3a://bucket/hive and > see what would happen. > > running this query: > > insert overwrite table

s3a and hive

2016-11-14 Thread Stephen Sprague
so i figured i try and set hive.metastore.warehouse.dir=s3a://bucket/hive and see what would happen. running this query: insert overwrite table omniture.hit_data_aws partition (date_key=20161113) select * from staging.hit_data_aws_ext_20161113 limit 1; yields this error: Failed with

Hive 2.2 binaries

2016-11-14 Thread Joaquin Alzola
Hi Guys I found out that I am having a inconsistency when running Hive2.1 with Spark2.0.1 Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/spark/JavaSparkListener Found out this JIRA: https://issues.apache.org/jira/browse/HIVE-14029 When is the Hive 2.2 binaries coming