Re: ODBC - NullPointerException when loading data

2017-02-02 Thread Gopal Vijayaraghavan
> Using Apache Hive 1.2.1, I get a NullPointerExcetion when performing a > request through an ODBC driver. > The request is just a simple LOAD DATA request: Looks like the NPE is coming from the getResultMetaData() call, which returns the schema of the rows returned. LOAD is probably one of

Re: Compactions doesn't launch on Hive 1.1.0

2017-02-02 Thread Gopal Vijayaraghavan
> I try reduce check interval and launch it manuallty with command "Alter > table tx_tbl compaction 'major';". Nothing helps. You can check the hive metastore log and confirm it also has the DbTxnManager set up & that it is triggering the compactions. Without a standalone metastore, the hive

Re: Compactions doesn't launch on Hive 1.1.0

2017-02-02 Thread Максим Буйлин
Thanks! In logs i only see messages of DummyTxnManager, nothing about DbTxnManager. When i connected to hive i use "set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;". How else i can configure transaction manager? 2017-02-02 11:12 GMT+03:00 Gopal Vijayaraghavan

edit wiki permissions

2017-02-02 Thread Anishek Agarwal
Hello, Can i please get edit permissions on the wiki, the username is "anishek" thanks anishek

Usage of complex types

2017-02-02 Thread Paras Sethia
Hi, I am trying a few queries in Hive using complex data types: > SELECT array(1, 2) a UNION ALL SELECT NULL; Error: Error while compiling statement: FAILED: SemanticException Schema of both sides of union should match: Column a is of type array on first table and type void on second table.

Re: edit wiki permissions

2017-02-02 Thread Lefty Leverenz
You got edit permissions back in November, Anishek. There should be an Edit icon in the upper right corner of each wiki page, as long as you're logged in . -- Lefty On Thu, Feb 2, 2017 at 9:33 PM, Anishek Agarwal wrote: >

Re: Compactions doesn't launch on Hive 1.1.0

2017-02-02 Thread Eugene Koifman
As Gopal said, you have to run a standalone metastore process for compactor to work. More on that in https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin#AdminManualMetastoreAdmin-RemoteMetastoreServer. Please note that the transaction specific configuration properties in

ODBC - NullPointerException when loading data

2017-02-02 Thread Pierre Villard
Hi, Using Apache Hive 1.2.1, I get a NullPointerExcetion when performing a request through an ODBC driver. The request is just a simple LOAD DATA request: LOAD DATA INPATH '/tmp/AYX170201a327cc8faf8e562f5eb86225dd1fbf57' INTO TABLE tmp.testpierre Logs can be found here: