FAQ
Hi Paisit,

Yes, Impala support %. See this:

http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Impala/ciiu_langref_sql.html?scroll=like_unique_1

If you just run "Select count(*) from customer", do you see any data at all?

Thanks,
Alan

On Fri, Jan 17, 2014 at 5:15 PM, Paisit Jarunnamsiri wrote:

Hi,
I'm using impala 1.2.3 CDH4. Can a like operator handle "%%"?
Here is a query: select * from from customer where c_last_name like
'%%';
I got 0 rows returned. When I tried the same query in hive, I got 100
rows returned.

Thanks,
Paisit

To unsubscribe from this group and stop receiving emails from it, send an
email to impala-user+unsubscribe@cloudera.org.
To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
groupimpala-user @
categorieshadoop
postedJan 18, '14 at 7:08a
activeJan 21, '14 at 9:30p
posts3
users3
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase