About saha_priyatam

saha_priyatam · ‎06-05-2017

I have a table which consists of eight column such as A,B,C,....H. Each column have some shortcodes such as U,V,W randomly.Now I need to count the no of U,V,W from each row.Some columns may have null or unknown value also. Here is a demo: A B C D E F G H U W V U W U U W V W W U V Here I need to use HiveQL.

saha_priyatam · ‎06-02-2017

You need to create external table then load data either from local or from HDFS. CREATE EXTERNAL TABLE <table_name> (column1 <datatype>,column2 <datatype>,column3 <datatype>,...) ROW FORMAT DELIMITED STORED AS SEQUENCEFILE LOCATION '<location_path>'; Now Load data : LOAD DATA INPATH '<HDFS PATH>' INTO <table_name>;

Online	Offline
Last Visited	‎06-05-2017 12:31 PM

Date Registered	‎06-02-2017 07:29 AM
Last Visited	‎06-05-2017 12:31 PM
Total Messages Posted	2

How do I count shortcodes from row in hive?

Re: Loading sequence files to Hive table