Member since
05-23-2017
28
Posts
10
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
24634 | 06-16-2017 12:14 PM |
08-29-2018
11:38 AM
mysql -u root -p hortonworks1
... View more
10-09-2017
11:15 AM
Thanks So much.. Worked like a charm!!
... View more
10-05-2017
07:35 PM
Desc <Table_name>; you'll come to know your table would have columns like _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9.. What you need to do is Add the alias to your existing table so that your column names are the actual names and not default _col1, etc.
... View more
07-07-2017
07:48 AM
@prsingh Hi, You're my life saviour. I tried checking the logs on the schedular website but just couldnt find it. and then I used this Yarn log and saved it into a log.txt file and there you go. Found the exact error that I was looking for. Thank you so much. 🙂
... View more
07-01-2017
12:53 PM
Try changing the execution engine to MR.. Run your query.. If its working fine. Change the execution engine to tez. this is how you do it. set hive.execution.engine=mr;
set hive.execution.engine=tez;
... View more
06-21-2017
12:44 PM
@Sonny Heer Apologies but I din get your question. Can you provide me with an example?
... View more
06-20-2017
06:25 AM
@Sonny Heer I think you can do that. Instead of this: Select B.b,B.key,ROW_NUMBER() OVER (partition by key) AS row_num from B)where row_num=1
You can use Select B.b,B.key,ROW_NUMBER() OVER (count by key) AS row_num from B)where row_num=1
Though I am not very sure, but Hive documentation says you can use standard aggregate in Over function. Check the link below: Hive Documentation Cheers, Sagar
... View more
06-20-2017
06:19 AM
@Bala Vignesh N V: I have never heard this thing. Windowing Function works only on 1 reducer... Thats only for Order by if I am not wrong.. Can you share any documentation If you have for the same.
... View more
06-19-2017
09:04 AM
2 Kudos
@Sateesh Mandumula Obviously You cannot have transactional Properties on top of external table as Hive just reads the file present in HDFS. Its not suppose to change the content of the External files. If you really want to use Transactional Property, Create an internal table select * from external table and use transaction properly on this internal table.
... View more