Hey Sanjeev.
Can you put the /tmp/hive/hive.log (on the hvevserver2 host) when you
launch the query ?
Best regards.
Tale
On Thu, Sep 22, 2016 at 5:03 AM, Sanjeev Verma
wrote:
> lowered 1073741824 to half of it but still getting the same issue.
>
> On Wed, Sep 21, 2016 at 6:44 PM, Sanjeev Verm
Hi Andres,
No that is not in UTC format. Plz see the description of that field below.
so if timezone of table2 is Europe/Amsterdam then we have to convert the
request_date of table1 in UTC Europe/Amsterdam timezone ( for example
2016-09-18 23:30:52). We have a lot of timezone entries in table2 and
Hi!
It seems that in Table1 you already have request_date in UTC format. *Z *at
the end of the timezone is the zone designator for the zero UTC offset.
Now all you have to do is to use standard Hive functions which you can find
from Hive wiki
https://cwiki.apache.org/confluence/display/Hive/Langu
Team,
I want to know whether there is any way in which I can run 3 hive queries
sequentially in a single jvm. From the docs, I found that setting "
mapreduce.framework.name=local" might achieve what I am looking for. Can
some one confirm?
- Rahul
Hello !
I send you this mail because I perform an hive query with Tez and it fails
with a strange error :
The error is like this :
###
ERROR : Vertex failed, vertexName=Reducer 2,
vertexId=vertex_1473870963805_157168_11_02, diagnostics=[Task failed,
taskId=task_1473870963805_157168_11_02_35,
Done. Welcome to the Hive wiki team, Ian!
-- Lefty
On Wed, Sep 21, 2016 at 10:03 AM, Ian Cook wrote:
> Hello,
>
> Could I please have write access to the Hive wiki so that I can help with
> fixes? My Confluence username is *icook*.
>
> Thanks,
> Ian Cook
> Cloudera
>
Hi Guys,
There is a scenario here that I am trying to implement
I have a table say table1 which contains aid and request_date in ISO 8601
format. I have one more table say table2 which contains aid and timezone
details. Now I want to convert request_date from table1 to UTC and apply
the timezone
Hi there,
The detailed error should be in the hiveserver2.log
Cheers, Andrew On Wed, Sep 21, 2016 at 3:36 PM, Igor Kravzov <
igork.ine...@gmail.com [igork.ine...@gmail.com] > wrote:
I run MSCK REPAIR TABLE mytable; and got Error while processing statement:
FAILED: Execution Error, return code
Thanks Nichole and Dudu for the reply. I got what I was looking for.
--Manish
On Thu, Sep 22, 2016 at 2:52 AM, Markovitz, Dudu
wrote:
> select to_date(ts),year(ts),month(ts),day(ts),hour(ts),minute(ts),second(ts)
> from (select from_unixtime (unix_timestamp
> ('2016-09-15T23:45:22.943762Z',"yy
