Hive JSON Serde Key Value string:string hcatalog

mignic1991 — Mon, 13 Nov 2017 20:41:50 GMT

I am trying to query the following Json file:

{"a":"a1","b":"b1","d":"{"key1":"pair1","key2":"pair2"}"}

I have created the following table to query it:

    CREATE EXTERNAL TABLE database.testingjson(
    	a STRING,
    	b STRING,
    	c STRING,
    	d map<string,string>
    )
    ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
    STORED AS TEXTFILE
    LOCATION 'location';

Shows the following exception:

    SQL Error: java.io.IOException: org.apache.hadoop.hive.serde2.SerDeException: java.io.IOException: Start of Object expected
      java.io.IOException: org.apache.hadoop.hive.serde2.SerDeException: java.io.IOException: Start of Object expected
        java.io.IOException: org.apache.hadoop.hive.serde2.SerDeException: java.io.IOException: Start of Object expected
          org.apache.hadoop.hive.serde2.SerDeException: java.io.IOException: Start of Object expected
            java.io.IOException: Start of Object expected
              java.io.IOException: Start of Object expected

If I delete the map from the table there is no problem and queries the data correctly. Is there anything that I'm missing? Or the hcatalog doesn't accept key value fields?

I'm using Hive 1.2

Re: Hive JSON Serde Key Value string:string hcatalog

ccotter — Mon, 13 Nov 2017 22:56:10 GMT

@Miguel Rodriguez

The JSON you are using isn't valid, you need to remove the double quotes around the map column value.

So your JSON would be:

{"a":"a1","b":"b1","d":{"key1":"pair1","key2":"pair2"}}

Re: Hive JSON Serde Key Value string:string hcatalog

mignic1991 — Mon, 13 Nov 2017 23:24:06 GMT

Oh god, thank you.

question Re: Hive JSON Serde Key Value string:string hcatalog in Archives of Support Questions (Read Only)

Hive JSON Serde Key Value string:string hcatalog

Re: Hive JSON Serde Key Value string:string hcatalog

Re: Hive JSON Serde Key Value string:string hcatalog