Hey thanks for the instructions!! However when i try to run hiveql query "alldata <- sqlFetch(myconn,"Select * from hivesampletable")", i get an error
Error in odbcTableExists(channel, sqtable) :
‘Select * from hivesampletable’: table not found on channel

would you know if im doing something wrong or is it with the settings or something? Please help!!
thanks,
Sada

hey i did not figure out the issue however i figured out a work around. instead of sqlFetch keyword we can use sqlquery which will the results. i guess this will still work!! but the question now is why sqlquery works but not the sqlfetch?
thanks,
sada