CREATE TABLE json_nested_test_openx (

    count string,

    usage string,

    pkg map<string,string>,

    languages array<string>,

    store map<string,array<map<string,string>>>)

ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'

STORED AS TEXTFILE;

CREATE TABLE s1 (

    count string,

    usage string

)

ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'

STORED AS TEXTFILE;

load data local inpath '/home/work/s1.txt' overwrite into table s1;

select * from s1;

CREATE TABLE s2 (

    count string,

    usage string,

    pkg map<string,string>

)

ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'

STORED AS TEXTFILE;

load data local inpath '/home/work/s2.txt' overwrite into table s2;

select * from s2;

CREATE TABLE s3 (

    count string,

    usage string,

    pkg map<string,string>,

    languages array<string>

)

ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'

STORED AS TEXTFILE;

load data local inpath '/home/work/s3.txt' overwrite into table s3;

select * from s3;

CREATE TABLE s4 (

    count string,

    usage string,

    pkg map<string,string>,

    languages array<string>,

    store map<string,array<map<string,string>>>

)

ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'

STORED AS TEXTFILE;

load data local inpath '/home/work/s4.txt' overwrite into table s4;

select * from s4;

CREATE TABLE s5 (

    store map<string,array<map<string,string>>>

)

ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'

STORED AS TEXTFILE;

load data local inpath '/home/work/s5.txt' overwrite into table s5;

select * from s5;

CREATE TABLE s6 (

    store map<string,array<string>>

)

ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'

STORED AS TEXTFILE;

load data local inpath '/home/work/s6.txt' overwrite into table s6;

select * from s6;