About rushikesh_veni

rushikesh_veni · ‎06-21-2016

Insert Overwrite is creating a CSV file as directory name and with a file named 000000_0 with all the content. How can I make this to create CSV file with exact name that I give like customershare.csv from above query ?

rushikesh_veni · ‎06-14-2016

Thanks Michael. I removed local keyword and it works fine now. Is there a specific location in local where it creates this in subdirectory by default ?

rushikesh_veni · ‎06-14-2016

I am trying to run this query to load data from Hive Table to HDFS file. IT executes successfully but does not show any CSV file in the directory(sTestData) in hdfs. Any suggestions on what may be wrong with query or the access to the hdfs directory ? INSERT OVERWRITE LOCAL DIRECTORY '/STestData/customershare.csv' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' SELECT * FROM stestdata.customershare

rushikesh_veni · ‎05-25-2016

I get same error and cannot see Hive Tables. Any fix for this yet ?

rushikesh_veni · ‎05-24-2016

Any fix for the issue yet ? I still have this issue . Is restarting ambari the only option ?

rushikesh_veni · ‎05-16-2016

I cannot verify the port from browser using this url : http://127.0.0.1:9065/thrift.jsp as I configured my infoport on 9065

rushikesh_veni · ‎05-16-2016

Josh, I tried configuring on different port using this command: hbase-daemon.sh start thrift --infoport 9065 -p 9060 But when I try browsing on that port locally, I do not see that working. Here is what in output when I run above command

rushikesh_veni · ‎05-16-2016

Thanks josh. whats the default port that HDP starts HBase Thrift Server on ? is 9090 configured to Nifi ?

rushikesh_veni · ‎05-16-2016

I am trying to get Thrift Server up and running as per steps mentioned here : https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_installing_manually_book/content/ref-2a6efe32-d0e1-4e84-9068-4361b8c36dc8.1.html but it throws error when I start thrift server, Port in use: 0.0.0.0:9095 . Can someone help in configuring thrift server on different port and make it accessible outside the server I have HDP installed on.

Online	Offline
Last Visited	‎06-21-2016 11:39 PM

Member Since	‎05-16-2016 06:22 PM
Last Visited	‎06-21-2016 11:39 PM
Posts	9
Kudos received	1

Cloudera Community

Re: Issue Loading Data from HIVE Table into CSV Fi...

Re: Issue Loading Data from HIVE Table into CSV Fi...

Issue Loading Data from HIVE Table into CSV File ...

Re: With Hive View what causes: "H100 Unable to su...

Re: H100 Unable to submit statement show databases...

Re: configuring Thrift Server on default port

Re: configuring Thrift Server on default port

Re: configuring Thrift Server on default port

configuring Thrift Server on default port