Re: Hive 2.1 and 1.2 fails on insert queries when metastore db is MSSQL SERVER > 2008

2017-05-23 Thread Sergey Shelukhin
This is fixed in https://issues.apache.org/jira/browse/HIVE-16106 which is unfortunately not yet in any release. From: Артем Великородный mailto:artem@gmail.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Tuesday, May 23, 2017 at 05:13

Load data inpath issue

2017-05-23 Thread Riccardo Iacomini
Hello, I am trying to execute a "LOAD DATA INPATH" statement using the jdbc driver into a partitioned orc table. The query is being executed, and the files are actually moved accordingly from the initial hdfs directory into the table assigned one (using the location keyword at table creation), but

Hive 2.1 and 1.2 fails on insert queries when metastore db is MSSQL SERVER > 2008

2017-05-23 Thread Артем Великородный
ENV: MS SQL 2012 on WINDOWS 10 HIVE 1.2.1, 2.1.1 Java 8 Metastore created by schematool (without any error) Insert query using MS SQL 2012 as metastore fails with: hive> CREATE TABLE test(i int); hive> INSERT INTO TABLE test values (1), (2); 2017-05-23T19:54:03,172 ERROR [pool-7-thread-2] *meta

Re: How to perform hive moveTask in parallel?

2017-05-23 Thread Rishi Aggarwal
Sujeet: It's gcs not s3. It might be boost performance, but since my table is partitioned copying is not straight forward. With Hive 2.1 files are moving in parallel. But partitioned are still moved one at a time. For example if there are 10 partitions and each partition has 100 files then within