Hi,
Windowing function row_number() over (PARTITION BY(col1,clo2,col3) throw
error on Empty Table in Hive Version .13
Is there any limitation using this function
Thanks,
Karthi
Hi Maciek, Jason
Sorry I could not find my old code but I came up with a little code as much
as I can remember.
you can try the following jar
https://github.com/nitinpawar/hive-udfs/tree/master/FromUnixtimeWithTZ/dist
and let me know if this works for you guys.
I can change it the way it needs to
Thank You, Alok and Devopam, it finally worked.
I was able to parse the query as hive parses it by taking guidance from the
hive codebase.
Regards,
Ritesh
On Thu, Nov 6, 2014 at 1:23 PM, Alok Kumar wrote:
> btw, what error are you getting with ANTLR or HiveParser? If any
> dependency class file
Hi guys,
I am trying to integrate Hive with HBase and perform a "with cube"
statement.
I just want to know how much of the native Hive sql like syntax is
actually supported when Hbase tables are used ?
I am still trying to programmatically integrate the Hbase tables, if
anyone has a success wit
My problem was that I configured in hive-site.xml this:
hive.exec.mode.local.auto
true
After setting it to false it works fine
2014-11-06 12:21 GMT+01:00 Juan Carlos :
> Thanks Matouk,
> I checked what you said, and finally I noticed that it's not the same
> running "/etc/init.d/hive-server2
Thanks Matouk,
I checked what you said, and finally I noticed that it's not the same
running "/etc/init.d/hive-server2 start" than "service hive-server2 start".
In the first case the CWD are being used by the script and it was causing
my issue.
Now I'm having another issue, after submiting the joi
What I'm referring to is CTAS statement and as per documentation it doesn't
seem to work (Hive 0.13).
I'm setting:
SET hive.exec.dynamic.partition=true;
SET hive.exec.dynamic.partition.mode=nonstrict;
and
CREATE TABLE dropme(key int, value string) PARTITIONED BY (yr int, mth int)
AS
SELECT 2 key,
@Jason:
re. "Hive (…) just assumes things are in the system's local timezone", just
to clarify - this is not true in case of conversions (from_unixtime()) as
it respects the local system TZ settings hence the problem.
TZ itself is a very hairy subject and would definitely be a big
undertaking. Exte
