Hive-JSON-Serde

Hive-JSON-Serde copied to clipboard

Accessing a sibling's value from a JSON Array in JSONserde

2

Hey, **Given** This is my JSON ``` ... "actions": [ { "action_type": "link_click", "value": "1" }, { "action_type": "page_engagement", "value": "1" }, { "action_type": "post_engagement", "value": "1" }, ..... ]...

saidatta

your code does not work with hbase ...why?

1

Why does your code not work with hbase? Is it the col mapping? I verified your example code works but clearly not with hbase. HBASE create 'MY_TABLE', {NAME=>'TEST', VERSIONS =>...

davidmontgom

Added DateIso8601 Support for Timestamp DataType

5

Added mainly isodate8601 format support acceptance and few corrections around javaStringByteObjectInspector and javaStringDoubleObjectInspector.

appanasatya

Support for ISO8601 date(time) strings

1

This PR is based on 'prezi/iso8601changes' and only includes the changes relevant for the ISO8601 parsing. I added a test for timestamps in UTC timezone.

static-max

1.3.8 not on http://www.congiu.net/hive-json-serde?

2

Was that released? There're no JARs on http://www.congiu.net/hive-json-serde/.

dblock

Supported table format

1

Hi, There is no mention in the documentation about the supported format : - textfile - RCfile - parquet - avro - orc Is textfile the only supported format ?...

parisni

hive version: 1.2.1 while when run the same hql in hive cli, the retured value are good. It seems like date type is not supported in serializeField function of https://github.com/rcongiu/Hive-JSON-Serde/blob/develop/json-serde/src/main/java/org/openx/data/jsonserde/JsonSerDe.java...

Yulei-Yang

The data load wrong after alter the table's column

1

Hi,I create a external partitioned table on HIVE 0.11 use JSON-Serde. The data like this（the partition is the date): {"player":{"play_count": 100, "play_from_daquan": 70, "play_from_home": 30}} {"player":{"less_5_count": 235200, "less_30_count": 3040}} {"player":{"play_count":...

briller

Column mappings are not working in hive 0.13 +

2

In Hive 0.13, a property was introduced hive.resultset.use.unique.column.names (https://issues.apache.org/jira/browse/HIVE-6687) which makes column names unique in the result set by qualifying column names with table alias if needed. Table alias will...

sunilkumar273

Have you submitted this to the core Hive project?

1

I suggest doing so. Hive cares about JSON support, as evidence by the two built-in functions now (get_json_object, json_tuple). Your SerDe is a better solution.

ChuckConnell