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 Plain View
Hive >> mail # user >> Re: Difference between like %A% and %a%


+
Sai Sai 2013-05-24, 10:59
+
Jov 2013-05-24, 11:09
+
Sai Sai 2013-05-24, 11:21
Copy link to this message
-
Re: Difference between like %A% and %a%
Your where clause looks at the abbreviation, requiring 'A', not the state
name. You got the correct answer.
On Fri, May 24, 2013 at 6:21 AM, Sai Sai <[EMAIL PROTECTED]> wrote:

> 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 <http://amutu.com/blog>
>
>
>
--
Dean Wampler, Ph.D.
@deanwampler
http://polyglotprogramming.com
+
John Omernik 2013-05-24, 13:07
+
Dean Wampler 2013-05-24, 13:16
+
Edward Capriolo 2013-05-24, 14:50
+
Dean Wampler 2013-05-24, 15:41
+
Edward Capriolo 2013-05-24, 15:58
+
Anthony Urso 2013-05-24, 19:44
+
Edward Capriolo 2013-05-24, 14:42
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