I wanted to create a table in Hive but throwing error. please check the attached image. The query snippet is given below CREATE TABLE bhaskar.hbase_gprs (daykey string, chrgd_amt INT, chrgd_amt_lcl INT, chrgd_amt_rpt INT, tot_drtn INT, tot_bytes_trnsfrd_outbnd INT, tot_bytes_trnsfrd_inbnd INT, tot_session INT) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping"=":daykey, chrgd:chrgd_amt, chrgd:chrgd_amt_lcl, chrgd:chrgd_amt_rpt, tot_drtn:tot_drtn, bytes_trnsfrd:tot_bytes_trnsfrd_outbnd, bytes_trnsfrd:tot_bytes_trnsfrd_inbnd, tot_session:tot_session") TBLPROPERTIES ("hbase.table.name"="dwd_data_usg_day","hbase.mapred.output.outputtable"="dwd_data_usg_day"); ... View more

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

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

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

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