Member since
04-01-2020
2
Posts
0
Kudos Received
0
Solutions
04-06-2020
01:22 AM
Hi MRajkumar, I added the the machine to the cluster, but interested in knowing if i don't add the machine to cluster and i want to setup client configuration for HDFS I am able to ping and update any file in HDFS but can i configure for hive as well to run hive qurery through command-line like below. USE schemaName; LOAD DATA INPATH '${HDFS_LOAD_DIR}/table.csv' OVERWRITE INTO TABLE table; 2nd question is: When i used HDFS client commands and placed the file under the hive warehouse table directory directly the data file i can see the same data when i query on hue, Note that mine is a single node cluster means only one data node is present. What if it is a multi node and many data nodes are present, in that case the file will be replicated in all of them, if i perform the below command will it be propagated? and replicated the same on all the data nodes? hdfs dfs -rm -r $TABLE_PATH/* hdfs dfs -copyFromLocal -f $dat/csvfilepath $TABLE_PATH my $TABLE_PATH is the warehouse directory+schamaname.db+/tablename $TABLE_PATH=/user/hive/warehouse/schema1.db/table Thank you.
... View more