suspicion that this is new behaviour for HIVE 3. Has anyone else
noticed this behaviour, can direct me to documentation about this?
Thank you, Eyal Ben Ivri
Add it to the distributed cache
add jar derby.jar;
or
use environment variable HIVE_AUX_JARS_PATH
On Mon, Nov 28, 2011 at 1:29 PM, Ghousia ghousia.ath...@gmail.com wrote:
Hi Chinna,
I have the derby.jar in the lib folder, hive runs fine and we are able to
execute the queries. Even then
Hi,
In MySQL to match '12684041234' to the longest prefix I would do
SELECT num_prefix
FROM nums
WHERE '12684041234' LIKE CONCAT(num_prefix, '%')
AND LENGTH(num_prefix) = (
SELECT MAX(LENGTH(num_prefix))
FROM nums
WHERE '12684041234' LIKE CONCAT(num_prefix, '%')
)
** Table nums has a column