from_unixtime() and epoch definition

2014-10-31 Thread Maciek
Any reason why select from_unixtime(0) t0 FROM … gives 1970-01-01 01:00:00 ? By all available definitions (epoch, from_unixtime etc..) I would expect it to be 1970-01-01 01:00:00…?

Re: from_unixtime() and epoch definition

2014-10-31 Thread Nitin Pawar
Do you have a copy paste error? I see both values as same On Fri, Oct 31, 2014 at 5:30 PM, Maciek mac...@sonra.io wrote: Any reason why select from_unixtime(0) t0 FROM … gives 1970-01-01 01:00:00 ? By all available definitions (epoch, from_unixtime etc..) I would expect it to be

Re: from_unixtime() and epoch definition

2014-10-31 Thread Nitin Pawar
In hive from_unixtime is returned from the timezone which you belong to From document : from_unixtime(bigint unixtime[, string format]) : Converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a string representing the timestamp of that moment in the current system time zone

Re: Support multilines in 1 record in Hive

2014-10-31 Thread Petter von Dolwitz (Hem)
Hi CL, as you noticed the getSplits method is not called on your InputFormat. I don't know the reason for this. The CombineHiveInputFormat only delegates some functionality to your own implementation. Basically you cannot control this without re-implementing the CombineHiveInputFormat. It will

Re: from_unixtime() and epoch definition

2014-10-31 Thread Maciek
Actually confirmed! It's down to the timezone settings I've moved temporarily server/client settings to 'Atlantic/Reykjavik' (no change in time comparing to what I was on (GMT), but it's permanent UTC and as such doesn't observe daylight saving. I believe this shouldn't matter (see my points from

Re: Hide HCatalog Metadata to unauthorized users

2014-10-31 Thread Peyman Mohajerian
one way is to use Hive's role based security: SQL Standard Based Authorization via hiveserver2: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Authorization#LanguageManualAuthorization-2SQLStandardsBasedAuthorizationinHiveServer2 available in hive .13. I'm also working for

Beeline client

2014-10-31 Thread Hanish Bansal
Hi, I am using Beeline client to connect to hiveserver2 on linux machine. In terminal when i run query: select * from table; It only show first few columns in case there is large no.of columns in table. There should be horizontal scroll on beeline if there is larger result but there is not any

Re: Beeline client

2014-10-31 Thread Vikas Parashar
Are you using CLI ? On Sat, Nov 1, 2014 at 12:33 AM, Hanish Bansal hanish.bansal.agar...@gmail.com wrote: Hi, I am using Beeline client to connect to hiveserver2 on linux machine. In terminal when i run query: select * from table; It only show first few columns in case there is large

Re: Beeline client

2014-10-31 Thread Hanish Bansal
Yeah beeline cli. On Sat, Nov 1, 2014 at 12:37 AM, Vikas Parashar para.vi...@gmail.com wrote: Are you using CLI ? On Sat, Nov 1, 2014 at 12:33 AM, Hanish Bansal hanish.bansal.agar...@gmail.com wrote: Hi, I am using Beeline client to connect to hiveserver2 on linux machine. In terminal

Re: Beeline client

2014-10-31 Thread Vikas Parashar
you can use shift+page up/down. On Sat, Nov 1, 2014 at 9:45 AM, Hanish Bansal hanish.bansal.agar...@gmail.com wrote: Yeah beeline cli. On Sat, Nov 1, 2014 at 12:37 AM, Vikas Parashar para.vi...@gmail.com wrote: Are you using CLI ? On Sat, Nov 1, 2014 at 12:33 AM, Hanish Bansal