You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by mahender bigdata <Ma...@outlook.com> on 2016/05/24 20:15:11 UTC
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 this feature.
/MS
RE: Any way in hive to have functionality like SQL Server collation
on Case sensitivity
Posted by "Markovitz, Dudu" <dm...@paypal.com>.
Yes, java_method is a Synonym for reflect as of Hive 0.9.0<https://issues.apache.org/jira/browse/HIVE-1877>
The use-case was presented by Mahender at the bottom of this thread (the emphasis is mine):
“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 this feature”.
From: Jörn Franke [mailto:jornfranke@gmail.com]
Sent: Thursday, July 14, 2016 10: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, Markovitz, Dudu <dm...@paypal.com>> wrote:
Are you referring to ‘java_method‘ (or ‘reflect’)?
e.g.
hive> select java_method ('java.lang.Math','min',45,9) ;
9
I’m not sure how it serves out purpose.
Dudu
From: Jörn Franke [mailto:jornfranke@gmail.com]
Sent: Thursday, July 14, 2016 8:55 AM
To: user@hive.apache.org<ma...@hive.apache.org>
Subject: Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity
You can use use any Java function in Hive without (!) the need to wrap it in an UDF via the reflect command.
however not sure if this meets your use case.
Sent from my iPhone
On 13 Jul 2016, at 19:50, Markovitz, Dudu <dm...@paypal.com>> wrote:
Hi
I’m personally not aware of other methods to achieve case insensitivity comparison but to use lower() / upper()
Dudu
From: Mahender Sarangam [mailto:Mahender.BigData@outlook.com]
Sent: Wednesday, July 13, 2016 12:56 AM
To: user@hive.apache.org<ma...@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 the Joins ? . Is there any setting applied at Hive Server level which gets reflected in all the queries ?
/MS
On 5/25/2016 9:05 AM, Markovitz, Dudu wrote:
It will not be suitable for 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.talebzadeh@gmail.com]
Sent: Wednesday, May 25, 2016 1:31 AM
To: user <us...@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 to directly compare two character strings based on alternate collation rules.
Hive does not have it. This is from SAP ASE
1> select compare ("aaa","bbb")
2> go
-----------
-1
(1 row affected)
1> select compare ("aaa","Aaa")
2> go
-----------
1
(1 row affected)
1> select compare ("aaa","AAA")
2> go
-----------
1
• The compare function returns the following values, based on the collation rules that you chose:
· 1 – indicates that char_expression1 or uchar_expression1 is greater than char_expression2 or uchar_expression2.
· 0 – indicates that char_expression1 or uchar_expression1 is equal to char_expression2 or uchar_expression2.
· -1 – indicates that char_expression1 or uchar_expression1 is less than char_expression2 or uchar expression2.
hive> select compare("aaa", "bbb");
FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'compare'
HTH
Dr Mich Talebzadeh
LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
On 24 May 2016 at 21:15, mahender bigdata <Ma...@outlook.com>> 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 already there, please let me know settings to enable this feature.
/MS
Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity
Posted by Jörn Franke <jo...@gmail.com>.
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, Markovitz, Dudu <dm...@paypal.com> wrote:
>
> Are you referring to ‘java_method‘ (or ‘reflect’)?
>
> e.g.
>
> hive> select java_method ('java.lang.Math','min',45,9) ;
> 9
>
> I’m not sure how it serves out purpose.
>
> Dudu
>
> From: Jörn Franke [mailto:jornfranke@gmail.com]
> Sent: Thursday, July 14, 2016 8:55 AM
> To: user@hive.apache.org
> Subject: Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity
>
>
> You can use use any Java function in Hive without (!) the need to wrap it in an UDF via the reflect command.
> however not sure if this meets your use case.
>
>
>
> Sent from my iPhone
> On 13 Jul 2016, at 19:50, Markovitz, Dudu <dm...@paypal.com> wrote:
>
> Hi
>
> I’m personally not aware of other methods to achieve case insensitivity comparison but to use lower() / upper()
>
> Dudu
>
> From: Mahender Sarangam [mailto:Mahender.BigData@outlook.com]
> Sent: Wednesday, July 13, 2016 12:56 AM
> To: 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 the Joins ? . Is there any setting applied at Hive Server level which gets reflected in all the queries ?
>
>
>
> /MS
>
>
> On 5/25/2016 9:05 AM, Markovitz, Dudu wrote:
> It will not be suitable for 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.talebzadeh@gmail.com]
> Sent: Wednesday, May 25, 2016 1:31 AM
> To: user <us...@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() 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> select compare ("aaa","bbb")
> 2> go
> -----------
> -1
> (1 row affected)
> 1> select compare ("aaa","Aaa")
> 2> go
> -----------
> 1
> (1 row affected)
>
> 1> select compare ("aaa","AAA")
> 2> go
> -----------
> 1
> · The compare function returns the following values, based on the collation rules that you chose:
>
> · 1 – indicates that char_expression1 or uchar_expression1 is greater than char_expression2 or uchar_expression2.
>
> · 0 – indicates that char_expression1 or uchar_expression1 is equal to char_expression2 or uchar_expression2.
>
> · -1 – indicates that char_expression1 or uchar_expression1 is less than char_expression2 or uchar expression2.
>
>
> hive> select compare("aaa", "bbb");
> FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'compare'
>
> HTH
>
>
>
>
> Dr Mich Talebzadeh
>
> LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>
> http://talebzadehmich.wordpress.com
>
>
> On 24 May 2016 at 21:15, mahender bigdata <Ma...@outlook.com> 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 already there, please let me know settings to enable this feature.
>
> /MS
>
>
>
RE: Any way in hive to have functionality like SQL Server collation
on Case sensitivity
Posted by "Markovitz, Dudu" <dm...@paypal.com>.
Are you referring to ‘java_method‘ (or ‘reflect’)?
e.g.
hive> select java_method ('java.lang.Math','min',45,9) ;
9
I’m not sure how it serves out purpose.
Dudu
From: Jörn Franke [mailto:jornfranke@gmail.com]
Sent: Thursday, July 14, 2016 8:55 AM
To: user@hive.apache.org
Subject: Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity
You can use use any Java function in Hive without (!) the need to wrap it in an UDF via the reflect command.
however not sure if this meets your use case.
Sent from my iPhone
On 13 Jul 2016, at 19:50, Markovitz, Dudu <dm...@paypal.com>> wrote:
Hi
I’m personally not aware of other methods to achieve case insensitivity comparison but to use lower() / upper()
Dudu
From: Mahender Sarangam [mailto:Mahender.BigData@outlook.com]
Sent: Wednesday, July 13, 2016 12:56 AM
To: user@hive.apache.org<ma...@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 the Joins ? . Is there any setting applied at Hive Server level which gets reflected in all the queries ?
/MS
On 5/25/2016 9:05 AM, Markovitz, Dudu wrote:
It will not be suitable for 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.talebzadeh@gmail.com]
Sent: Wednesday, May 25, 2016 1:31 AM
To: user <us...@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 to directly compare two character strings based on alternate collation rules.
Hive does not have it. This is from SAP ASE
1> select compare ("aaa","bbb")
2> go
-----------
-1
(1 row affected)
1> select compare ("aaa","Aaa")
2> go
-----------
1
(1 row affected)
1> select compare ("aaa","AAA")
2> go
-----------
1
• The compare function returns the following values, based on the collation rules that you chose:
· 1 – indicates that char_expression1 or uchar_expression1 is greater than char_expression2 or uchar_expression2.
· 0 – indicates that char_expression1 or uchar_expression1 is equal to char_expression2 or uchar_expression2.
· -1 – indicates that char_expression1 or uchar_expression1 is less than char_expression2 or uchar expression2.
hive> select compare("aaa", "bbb");
FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'compare'
HTH
Dr Mich Talebzadeh
LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
On 24 May 2016 at 21:15, mahender bigdata <Ma...@outlook.com>> 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 already there, please let me know settings to enable this feature.
/MS
Re: Any way in hive to have functionality like SQL Server collation on Case sensitivity
Posted by Jörn Franke <jo...@gmail.com>.
You can use use any Java function in Hive without (!) the need to wrap it in an UDF via the reflect command.
however not sure if this meets your use case.
Sent from my iPhone
> On 13 Jul 2016, at 19:50, Markovitz, Dudu <dm...@paypal.com> wrote:
>
> Hi
>
> I’m personally not aware of other methods to achieve case insensitivity comparison but to use lower() / upper()
>
> Dudu
>
> From: Mahender Sarangam [mailto:Mahender.BigData@outlook.com]
> Sent: Wednesday, July 13, 2016 12:56 AM
> To: 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 the Joins ? . Is there any setting applied at Hive Server level which gets reflected in all the queries ?
>
>
>
> /MS
>
>
> On 5/25/2016 9:05 AM, Markovitz, Dudu wrote:
> It will not be suitable for 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.talebzadeh@gmail.com]
> Sent: Wednesday, May 25, 2016 1:31 AM
> To: user <us...@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() 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> select compare ("aaa","bbb")
> 2> go
> -----------
> -1
> (1 row affected)
> 1> select compare ("aaa","Aaa")
> 2> go
> -----------
> 1
> (1 row affected)
>
> 1> select compare ("aaa","AAA")
> 2> go
> -----------
> 1
> · The compare function returns the following values, based on the collation rules that you chose:
>
> · 1 – indicates that char_expression1 or uchar_expression1 is greater than char_expression2 or uchar_expression2.
>
> · 0 – indicates that char_expression1 or uchar_expression1 is equal to char_expression2 or uchar_expression2.
>
> · -1 – indicates that char_expression1 or uchar_expression1 is less than char_expression2 or uchar expression2.
>
>
> hive> select compare("aaa", "bbb");
> FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'compare'
>
> HTH
>
>
>
>
> Dr Mich Talebzadeh
>
> LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>
> http://talebzadehmich.wordpress.com
>
>
> On 24 May 2016 at 21:15, mahender bigdata <Ma...@outlook.com> 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 already there, please let me know settings to enable this feature.
>
> /MS
>
>
>
RE: Any way in hive to have functionality like SQL Server collation
on Case sensitivity
Posted by "Markovitz, Dudu" <dm...@paypal.com>.
Hi
I’m personally not aware of other methods to achieve case insensitivity comparison but to use lower() / upper()
Dudu
From: Mahender Sarangam [mailto:Mahender.BigData@outlook.com]
Sent: Wednesday, July 13, 2016 12:56 AM
To: 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 the Joins ? . Is there any setting applied at Hive Server level which gets reflected in all the queries ?
/MS
On 5/25/2016 9:05 AM, Markovitz, Dudu wrote:
It will not be suitable for 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.talebzadeh@gmail.com]
Sent: Wednesday, May 25, 2016 1:31 AM
To: user <us...@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 to directly compare two character strings based on alternate collation rules.
Hive does not have it. This is from SAP ASE
1> select compare ("aaa","bbb")
2> go
-----------
-1
(1 row affected)
1> select compare ("aaa","Aaa")
2> go
-----------
1
(1 row affected)
1> select compare ("aaa","AAA")
2> go
-----------
1
• The compare function returns the following values, based on the collation rules that you chose:
· 1 – indicates that char_expression1 or uchar_expression1 is greater than char_expression2 or uchar_expression2.
· 0 – indicates that char_expression1 or uchar_expression1 is equal to char_expression2 or uchar_expression2.
· -1 – indicates that char_expression1 or uchar_expression1 is less than char_expression2 or uchar expression2.
hive> select compare("aaa", "bbb");
FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'compare'
HTH
Dr Mich Talebzadeh
LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
On 24 May 2016 at 21:15, mahender bigdata <Ma...@outlook.com>> 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 already there, please let me know settings to enable this feature.
/MS
Re: Any way in hive to have functionality like SQL Server collation
on Case sensitivity
Posted by Mahender Sarangam <Ma...@outlook.com>.
Thanks Dudu,
I would like to know dealing with case in-sensitivity in other project. is every one converting to toLower() or toUpper() in the Joins ? . Is there any setting applied at Hive Server level which gets reflected in all the queries ?
/MS
On 5/25/2016 9:05 AM, Markovitz, Dudu wrote:
It will not be suitable for 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.talebzadeh@gmail.com]
Sent: Wednesday, May 25, 2016 1:31 AM
To: user <us...@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 to directly compare two character strings based on alternate collation rules.
Hive does not have it. This is from SAP ASE
1> select compare ("aaa","bbb")
2> go
-----------
-1
(1 row affected)
1> select compare ("aaa","Aaa")
2> go
-----------
1
(1 row affected)
1> select compare ("aaa","AAA")
2> go
-----------
1
• The compare function returns the following values, based on the collation rules that you chose:
· 1 – indicates that char_expression1 or uchar_expression1 is greater than char_expression2 or uchar_expression2.
· 0 – indicates that char_expression1 or uchar_expression1 is equal to char_expression2 or uchar_expression2.
· -1 – indicates that char_expression1 or uchar_expression1 is less than char_expression2 or uchar expression2.
hive> select compare("aaa", "bbb");
FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'compare'
HTH
Dr Mich Talebzadeh
LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
On 24 May 2016 at 21:15, mahender bigdata <Ma...@outlook.com>> 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 already there, please let me know settings to enable this feature.
/MS
RE: Any way in hive to have functionality like SQL Server collation
on Case sensitivity
Posted by "Markovitz, Dudu" <dm...@paypal.com>.
It will not be suitable for 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.talebzadeh@gmail.com]
Sent: Wednesday, May 25, 2016 1:31 AM
To: user <us...@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 to directly compare two character strings based on alternate collation rules.
Hive does not have it. This is from SAP ASE
1> select compare ("aaa","bbb")
2> go
-----------
-1
(1 row affected)
1> select compare ("aaa","Aaa")
2> go
-----------
1
(1 row affected)
1> select compare ("aaa","AAA")
2> go
-----------
1
• The compare function returns the following values, based on the collation rules that you chose:
· 1 – indicates that char_expression1 or uchar_expression1 is greater than char_expression2 or uchar_expression2.
· 0 – indicates that char_expression1 or uchar_expression1 is equal to char_expression2 or uchar_expression2.
· -1 – indicates that char_expression1 or uchar_expression1 is less than char_expression2 or uchar expression2.
hive> select compare("aaa", "bbb");
FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'compare'
HTH
Dr Mich Talebzadeh
LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
On 24 May 2016 at 21:15, mahender bigdata <Ma...@outlook.com>> 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 already there, please let me know settings to enable this feature.
/MS
Re: Any way in hive to have functionality like SQL Server collation
on Case sensitivity
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 strings based on alternate
collation rules.
Hive does not have it. This is from SAP ASE
1> select compare ("aaa","bbb")
2> go
-----------
-1
(1 row affected)
1> select compare ("aaa","Aaa")
2> go
-----------
1
(1 row affected)
1> select compare ("aaa","AAA")
2> go
-----------
1
-
The *compare* function returns the following values, based on the collation
rules that you chose:
-
1 – indicates that *char_expression1* or *uchar_expression1* is greater
than *char_expression2* or* uchar_expression2*.
-
0 – indicates that *char_expression1* or *uchar_expression1* is equal to
*char_expression2* or* uchar_expression2*.
-
-1 – indicates that *char_expression1* or *uchar_expression1* is less
than *char_expression2 *or* uchar expression2*.
hive> select compare("aaa", "bbb");
FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'compare'
HTH
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 24 May 2016 at 21:15, mahender bigdata <Ma...@outlook.com>
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 already there, please let me know settings to enable
> this feature.
>
> /MS
>
>
Re: Any way in hive to have functionality like SQL Server collation
on Case sensitivity
Posted by mahender bigdata <Ma...@outlook.com>.
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 already there, please let me know settings
> to enable this feature.
>
> /MS
>