To unsubscribe from the Hive user mailing list, please send a message to
user-unsubscr...@hive.apache.org as described here: Mailing Lists
http://hive.apache.org/mailing_lists.html.
-- Lefty
On Tue, Feb 17, 2015 at 11:28 PM, Payal Radheshamji Agrawal
payal.agra...@datametica.com wrote:
Compile native libraries and put them in path.
Sent from my iPhone
On Feb 17, 2015, at 11:24 PM, Baveja, Ankush ankush.bav...@rsa.com wrote:
Hi,
Newbie and trying to do some custom script. Not exactly hive related, so
kindly bear
When I run hadoop fs –ls, I get below output
You can call a function created in another database by using the fully
qualified function name - select db_name.function_name(…) from …
This is similar to referencing tables from other databases in your query.
On Feb 17, 2015, at 8:03 PM, vengatesh.babu
hi Philippe,
Performance improvement has two factors : 1. availability (read abundance)
of resources 2.need for speed
All advise usually is to address mainly these two factors , as I have
usually seen till this far.
Since you are doing a full scan each day for identify dedups I suggested
keeping
Hi Dev,
Only suggestion is that please don't compress the files that are linked
in the external table .
Why do you suggest that ? Presently, I divide my import time by 2 by using
'gz' files instead of the uncompressed 'csv'.
You may want to leverage dynamic partition
I read you post, and I
I believe this is due to https://issues.apache.org/jira/browse/HIVE-9278, which
has been fixed in trunk (also 1.0).
This affects UDFs using the old-style UDF classes (which include
hour()/minute()/second())
A workaround is to do set hive.cache.expr.evaluation=false; before running
the query.
I have a unix time that I need to convert time-zones and then do some
calculations on it. In the end I want to create a fractional hour (15:30 -
15.5). We are at Hive 0.14.0.2.2.0.0-2041
I have the following Hive test query:
select
time_from_epoch,
cast(hour( from_utc_timestamp(
That did fix my issue. Thanks!
Craig
On Wed, Feb 18, 2015 at 2:56 PM, Jason Dere jd...@hortonworks.com wrote:
I believe this is due to https://issues.apache.org/jira/browse/HIVE-9278,
which has been fixed in trunk (also 1.0).
This affects UDFs using the old-style UDF classes (which include