Member since
11-30-2020
5
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2630 | 12-10-2021 02:14 PM |
04-28-2022
03:41 AM
Hi @RafaelDiaz, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. If you are still experiencing the issue, can you provide the information @MohanG has requested?
... View more
12-10-2021
02:14 PM
1 Kudo
It is already solved, it was only missing in the CREATE TABLE to add the sandbox path CLD_ML_BI_ENG.iris dbExecute(conn = con_Hive,
statement = "CREATE EXTERNAL TABLE CLD_ML_BI_ENG.iris(sepal_length double, sepal_width double, petal_length double, petal_width double, species varchar(10))
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
LOCATION '/sandbox/CLD_ML_BI_ENG/iris'")
... View more
11-12-2021
02:15 AM
AFAIK the table location should be set at the time of Creation. You can set files in a different location. You can use ALTER TABLE jsont1 SET LOCATION "hdfs://mycluster:8020/jsam/j1"; to change the location and need to move the files manually from old location to new location.
... View more