Hi Faisal,
Yes you can use a built-in Boolean function as you've shown in your query.
You can also omit the =TRUE part like this:
SELECT name
FROM profileTable
WHERE name LIKE 'Ale%' AND *myFunc*(name);
How this is processed depends on whether or not the table is salted and
the name is the leadin
When you run
$ bin/hbase classpath
What do you get? Should help illuminate if everything is setup right.
If the phoenix jar is there, then check the contents of the jar (
http://docs.oracle.com/javase/tutorial/deployment/jar/view.html) and make
sure the classes are present.
On Aug 9, 2014 1:03
Hi,
If have a query:
SELECT name
FROM profileTable
WHERE name LIKE 'Ale%' AND *myFunc*(name)=TRUE;
I have two questions:
1) Can I use *myFunc* in the WHERE clause if my function return boolean.
2) If yes, how would Phoenix translate it into get/scan request. Will it
first use a scan to get al
Hi Jesse,
I ran the following code to test the existence of the classes you asked me
to check. I initialized the two constants to the following values.
===
public static final String INDEX_WAL_EDIT_CODEC_CLASS_NAME =
"org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec";
public stat
