Hive-JSON-Serde
Hive-JSON-Serde copied to clipboard
rcongiu
Read - Write JSON SerDe for Apache Hive.
I am able to create table and process data for single line JSON data but my question is can I process JSON data like below: ``` [{ "field1": "data1", "field2":...
Hi, First i would like to thank you for your great job. Here is my problem : i'm using hive 0.12 on cdh 5.0 and i'm trying to create a...
Hi, I am unable to achieve below functionality on my data, any have suggestions? i/p: { "details": {"ROW":[ {"company":"xyz", "domain":"123", "items":{"ROW":[{"shoes":"Nike","shirt":""},{"shoes":"Fila","shirt":""}]} }, {"company":"x", "domain":"12", "items":{"ROW":[]} } ] }, "send":"me" }...
Given a JSON file: ```json { "id": "1234", "timestamp": "2018-05-31 00:00:00", "foo": { "key1": null, "key2": "value" } } ``` Using the following table create: ``` CREATE EXTERNAL TABLE test_table...
Say I have the following table ``` window string ``` and at some point I want to rename `window` because the process that it outputting data to my data lake...
Hi, Given a dynamic-sized array of the form [{"aa" : "bb"}, {"aa" : "cc"}, {"aa":"dd"}] There seem to be no solution with the serde other than defining 3 struct. an...
Is there a way to map the value of json to some new value in hive? E.g. if import {"key":"value"} pair to a hive table, when I do "select key...
How should the request for adding data not from a file? Like: insert into test_table values {one: true, three: ['white'], two: 666.777, four: 'side'''}.
Hi All! I'm have an issue while querying a table that makes Hive use MapReduce Jobs. When I query the data using "Select * from Table", it returns the error...
We dont seem to be serializing null values, are there plans to add this feature? Thanks!
