Good Morning.
I am doing a small example with HIVE and MANAGED TABLE.
My environment is Oracle VM virtual Box 6.0
Hive 1.1.0-cdh5.13.0
I indicate the steps I have taken:
1st)
CREATE DATABASE scenariox
2nd)
USE scenariox
CREATE TABLE scenariox
(
smallint order;
name string;
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
3rd) I load the table with my csv file that is stored in HDFS
HDFS> /scenariox/scenariox.csv
LOAD DATA LOCAL INPATH '/scenariox/scenariox.csv' INTO TABLE scenariox
The table loads correctly. I can run: '' Select * from scenariox ''. I recover data correctly. The table has been loaded successfully.
The directories in hive are created correctly:
/user/hive/warehouse/scenariox.db/scenariox/scenariox.csv
I execute the sentence: SELECT COUNT (1) FROM scenariox;
MAP / REDUCE launched
My problem is: I can't find the output file that produces the map / reduce.
What directory is it stored in? I thought that a file of type '00000_0' was generated and stored in the HDFS.
Can somebody help me? Thank you. Greetings
Created 10-12-2019 08:29 PM
Want to get a detailed solution you have to login/registered on the community
Register/LoginCreated 10-12-2019 08:29 PM
Want to get a detailed solution you have to login/registered on the community
Register/LoginCreated 10-14-2019 01:13 AM
@Shu_ashu Great!. With the instructions you have given me, the output file is created correctly. I also tried the option: CREATE TABLE AS scenariox_out AS SELECT select count (*) from scenariox; And the output file was created in: /user/hive/warehouse/scenariox.db/scenariox/scenariox_out/000000_0 Thank you. You have a good day