0 0 votes When I am using the select statement to display my data in hive. It displays my data in scattered format. I want to add a delimiter so that when data is been displayed it should be in proper table format. Cloud Computing cloud-computing gcp hive + – Harshini 140 points 1 1 7 answer comment Share See all 5 Comments 5 5 Comments reply tofighi 116k points 73 79 101 commented Feb 8, 2020 reply flag Your question is vague. Clarify it with an example. 0 0 replyShare Rajat Garg 480 points 7 commented Feb 8, 2020 reply flag Even when I'm also selecting any query, I'm also getting data in below scattered format not in proper table format. Is it what your're asking for? audi v8 1092371.4167 mitsubishi lancer 802800.5560 mazda 392644.0280 lamborghini 368726.7639 ford escort 348085.0830 citroen xm 342516.2405 lamborghini aventador 320291.0645 honda 280090.3007 bmw z8 223893.0000 fiat brava 178872.4219 0 0 replyShare Harshini 140 points 1 1 7 commented Feb 9, 2020 i edited by Harshini Feb 9, 2020 reply flag I have added more details to my question. Here, is the link to my screenshot: https://paste.pics/eaf6061ca22258c92491b419694c78a6 0 0 replyShare tofighi 116k points 73 79 101 commented Feb 10, 2020 reply flag It seems you did not define the right delimiter. You should take a look at some of your data rows to choose the right delimiter. For example, you need to add this to "create table" command if the fields are separated by a semicolon: ROW FORMAT DELIMITED FIELDS TERMINATED BY '\;' 0 0 replyShare Harshini 140 points 1 1 7 commented Feb 11, 2020 reply flag I did try this but it is not working for me. 0 0 replyShare Please log in or register to add a comment.
Courses
Feedback
