mysql -u root -p hortonworks1 ... View more

hortonworks1 --> This is the pwd ... View more

Thanks So much.. Worked like a charm!! ... View more

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

@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

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

@Sonny Heer Apologies but I din get your question. Can you provide me with an example? ... View more

@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

@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

@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