Member since
06-15-2017
6
Posts
0
Kudos Received
0
Solutions
09-12-2017
05:48 PM
I want to load the extracted data(without semi-colon, double-quote and comma) from this csv dataset into Hive table. I don't want to use any external programming language how it can be done? INPUT BOOK-RATING.csv DATASET : "User-ID;""ISBN"";""Book-Rating""",,
"276725;""034545104X"";""0""",,
"276726;""0155061224"";""5""",,
"276727;""0446520802"";""0""",,
"276729;""052165615X"";""3""",,
"276729;""0521795028"";""6""",,
"276733;""2080674722"";""0""",,
"276736;""3257224281"";""8""",,
"276737;""0600570967"";""6""",,
"276744;""038550120X"";""7""",,
"276745;""342310538"";""10""",, AFTER LOADING INTO HIVE TABLE VIEW SHOULD BE IN 3 COLUMNS: 276725 034545104X 0
276726 0155061224 5
276727 0446520802 0
276729 052165615X 3
276729 0521795028 6
276733 2080674722 0
276736 3257224281 8
276737 0600570967 6
276744 038550120X 7
276745 342310538 10
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
09-11-2017
03:19 AM
I got your nice explanation, Thanks! but will you please tell me what is distinct copy function's exact meaning of the sense over here?
... View more
09-11-2017
02:14 AM
If there are m mappers and n reducers, then what is the no of distinct copy functions? PLEASE ELABORATE BEHIND THE ANSWER! Which one is the answer? The Options Are given below:
m^n m*n m+n n m
... View more
Labels:
- Labels:
-
Apache Hadoop
09-08-2017
11:01 AM
I want to understand in depth concept of the reason behind that if we want to iterate through the values in reverse order-the bytes of the actual value should be written twice. Thanks with regards!
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache HBase
06-15-2017
07:08 AM
Is it possible to create an Encryption Zone in the HDFS or Hive Warehouse, when we will put or load any data or table into encryption zone location then it will get encrypted automatically?
... View more
Labels: