Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: Difference between like %A% and %a%


Copy link to this message
-
Re: Difference between like %A% and %a%
But it should get more results for this:

%a%

than for

%A%

Please let me know if i am missing something.
Thanks
Sai

________________________________
 From: Jov <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; Sai Sai <[EMAIL PROTECTED]>
Sent: Friday, 24 May 2013 4:39 PM
Subject: Re: Difference between like %A% and %a%
 
2013/5/24 Sai Sai <[EMAIL PROTECTED]>

abbreviation l
unlike MySQL, string in Hive is case sensitive,so '%A%' is not equal with '%a%'.
--
Jov

blog: http:amutu.com/blog
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB