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:[email protected]]
Sent: Thursday, July 14, 2016 8:55 AM
To: [email protected]
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
<[email protected]<mailto:[email protected]>> 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:[email protected]]
Sent: Wednesday, July 13, 2016 12:56 AM
To: [email protected]<mailto:[email protected]>
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:[email protected]]
Sent: Wednesday, May 25, 2016 1:31 AM
To: user <[email protected]><mailto:[email protected]>
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
<[email protected]<mailto:[email protected]>> 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
