Hello Sanita,
If you use a JSON try to add the jar 'hive-json-serde.jar' before you
upload your data in the final table. And also try to make your date
attributes in String format first to debug (if this is the cause).
I don't know if you are using an external table with regular expressions
Yup, it was the directory structure com/mystuff/whateverUDF.class that was
missing. Thought I had tried that before posting my question, but...
Thanks for your help!
From: Edward Capriolo edlinuxg...@gmail.com
To: user@hive.apache.org user@hive.apache.org;
Hi guys
Any chance I could get cwiki update privileges today ?
Thanks
sanjay
From: Sanjay Subramanian
sanjay.subraman...@wizecommerce.commailto:sanjay.subraman...@wizecommerce.com
Date: Tuesday, July 30, 2013 4:26 PM
To: user@hive.apache.orgmailto:user@hive.apache.org
Thanks Nitin
There arent too many connections in close_wait state only 1 or two when we
run into this. Most likely its because of dropped connection.
I could not find any read or write timeouts we can set for the thrift
server which will tell thrift to hold on to the client connection.
See this
Seems it is another problem.
Can you try
SELECT *
FROM (SELECT VAL001 x1,
VAL002 x2,
VAL003 x3,
VAL004 x4,
VAL005 y
FROM (SELECT /*+ mapjoin(v2) */ (VAL001- mu1) * 1/(sd1) VAL001,
(VAL002- mu2) * 1/(sd2) VAL002,
I just uploaded a patch to https://issues.apache.org/jira/browse/HIVE-4968.
You can try it and see if the problem has been resolved for your query.
On Wed, Jul 31, 2013 at 11:21 AM, Yin Huai huaiyin@gmail.com wrote:
Seems it is another problem.
Can you try
SELECT *
FROM (SELECT VAL001
from here:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-RelationalOperators
A RLIKE B stringsNULL if A or B is NULL, TRUE if any (possibly empty)
substring of A matches the Java regular expression B, otherwise FALSE. E.g.
'foobar' RLIKE 'foo' evaluates to
I'm facing issues while building an index on multiple columns in a Hive(0.9.0)
table.
describe nas_comps;
OK
leg_id int
ds_name string
dep_datestring
crr_codestring
flight_no string
orgnstring
dstnstring
physical_capint
adjusted_capint
closed_cap