Hi All,
I have JSON data Can I create table without schema? and query that data,
since all my data os JSON data so I was thinking there should be some way.
Currently I am doing something like below, but I want to remove Schema from
this, because I have i ma having thousand of event type and all of them i
cant really create the schema, Highlighted part I want to remove and let
the hive decide the schema.
create external table if not exists impressions_data
(
* city string,*
* service string,*
* id int,*
* type string,*
* listings int,*
* visible_markers int,*
* visible_as_markers int,*
* city_id int,*
* location_type string,*
* polygon_id string,*
* polygon_name string,*
* BuyListViewCount string,*
* AutoSuggest string,*
* LocalityExpert string,*
* BuyerExperiment string,*
* SellerExperiment string,*
* PaidAdProducts string,*
* index_view_type string,*
* page_type string,*
* clid string,*
* device string,*
* results_by_profile string,*
* listing_index int,*
* huid string,*
* uid string,*
* sid int,*
* count int,*
* category string,*
* action string,*
* url string,*
* `timeStamp` bigint)*
partitioned by (`date` string)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION 'hdfs://
hadoop01.housing.com:8020/housing/events/validated/category=impressions/';
MSCK REPAIR TABLE impressions_data;
SHOW PARTITIONS impressions_data;
select * from impressions_data limit 1;
