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

:43 AM To: user@hive.apache.org Subject: Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity I think both are the same. can you elaborate a little bit more on your use case, eg a query you currently do and what the exact issue is On 14 Jul 2016, at 09:36, Mar

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

or JOIN operation since it will cause a Cartesian > product. > Any chosen solution should determine a single representation for any given > string. > > Dudu > > From: Mich Talebzadeh [mailto:mich.talebza...@gmail.com] > Sent: Wednesday, May 25, 2016 1:31 AM > To: user > S

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

6 AM To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity Thanks Dudu, I would like to know dealing with case in-sensitivity in other project. is every one converting to toLower() or toUpper() in

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

given > string. > > Dudu > > From: Mich Talebzadeh [mailto:mich.talebza...@gmail.com] > Sent: Wednesday, May 25, 2016 1:31 AM > To: user > Subject: Re: Any way in hive to have functionality like SQL Server collation > on Case sensitivity > > I would rather go f

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

: Wednesday, May 25, 2016 1:31 AM To: user <mailto:user@hive.apache.org> Subject: Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity I would rather go for something like compare() <http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc3

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

ser@hive.apache.org> Subject: Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity I would rather go for something like compare() <http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36271.1572/html/blocks/X14054.htm> that allows one

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

way in hive to have functionality like SQL Server collation on Case sensitivity I would rather go for something like compare() <http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36271.1572/html/blocks/X14054.htm> that allows one to directly compare two character s

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

ping.. On 5/24/2016 1:15 PM, mahender bigdata wrote: 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

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>