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
... View more
