Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity

I would rather go for something like compare() that allows one to directly compare two character strings based on alternate collation rules. Hive does not have it. This is from SAP ASE 1>

Re: Insert query with selective columns in Hive

This should work Mine is Hive 2 hive> create table testme (col1 int, col2 int, col3 int, col4 int); OK Time taken: 4.006 seconds hive> insert into testme values(1,2,3,4); Loading data to table test.testme OK Time taken: 70.844 seconds hive> insert into testme (col1,col2,col3,col4) values(1,2,3,4)

Any way in hive to have functionality like SQL Server collation on Case sensitivity

Hi, We would like to have feature in Hive where string comparison should ignore case sensitivity while joining on String Columns in hive. This feature helps us in reducing code of calling Upper or Lower function on Join columns. If it is already there, please let me know settings to enable th

Insert query with selective columns in Hive

Hi, Is there a way in Hive to insert specific columns rather than insert query with all columns options. Like I have table with 10 columns, in my insert statement, i would like to insert only 3 columns like below insert into tbl1 (col1,col2,col10) values (1,2,3); insert into tbl1 (col1,col2

Hive 2 loss of connection to metadstore and multiple connections/disconnect in the same session

Hi, I am seeing thie in hive.log. The job finishes OK but hive makes multiple connection/disconnect to metastorte (in my case Oracle). in the same session It recovers from error but are these multiple connections and disconnects necessary? Every time a Java thread tries to make a connection to da

[RESULT] Bylaws change to allow some commits without review

The vote has succeeded with 15 +1 votes and 1 -0 vote. I have made the Bylaws draft at < https://cwiki.apache.org/confluence/display/Hive/Proposed+Changes+to+Hive+Project+Bylaws+-+April+2016> the current version at < https://cwiki.apache.org/confluence/display/Hive/Bylaws>. Thanks again everyone

Re: Using Spark on Hive with Hive also using Spark as its execution engine

Hi, We use Hive as the database and use Spark as an all purpose query tool. Whether Hive is the write database for purpose or one is better off with something like Phoenix on Hbase, well the answer is it depends and your mileage varies. So fit for purpose. Ideally what wants is to use the faste