tajo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jihoon Son <ghoon...@gmail.com>
Subject Re: JSON table
Date Thu, 01 Oct 2015 17:11:15 GMT
Record data type is also supported from 0.11.
If your data is a nested json, you should use some functions to retrieve
nested fields. (The functions to retrieve json fields are listed in our
document.)
So, I recommend to use 0.11.
2015년 10월 1일 (목) 오후 8:03, Jihoon Son <ghoonson@gmail.com>님이 작성:

> Hi, which version of tajo are you using?
> That star notation is newly supported from 0.11.
> We are currently testing an rc of 0.11, and you can download it at
> https://dist.apache.org/repos/dist/dev/tajo/tajo-0.11.0-rc0/.
>
> Thanks,
> Jihoon
>
> 2015년 10월 1일 (목) 오후 7:50, Odin Guillermo Caudillo Gallegos
> odin.guillermo@gmail.com>님이 작성:
>
> Hi , i just tried to create the table like the example on the slide, but
>> it's giving me an error:
>> CREATE EXTERNAL TABLE jsonTable (*) USING json Location
>> 'hdfs://hadoopMaster:9000/InputJson.json';
>> ERROR: syntax error at or near '*'
>>
>> I'm using the (*) because the json have a tag "Event-Time" so the column
>> name couldn't be Event-Time
>> Thanks
>>
>> 2015-10-01 10:41 GMT-05:00 Jihoon Son <ghoonson@gmail.com>:
>>
>>> Actually, you don't have to convert your json file. Instead, you can
>>> create a tajo table for it.
>>> You have two choices.
>>> First is defining all the columns. Another choice is using the
>>> schemaless concept.
>>> You can see some examples at 36 and 38 pages of this slide.
>>>
>>> http://www.slideshare.net/jihoonson/introduction-to-apache-tajo-data-warehouse-for-big-data
>>>
>>> Thanks,
>>> Jihoon
>>>
>>> 2015년 10월 2일 (금) 오전 12:22, Odin Guillermo Caudillo Gallegos <
>>> odin.guillermo@gmail.com>님이 작성:
>>>
>>>> Hi, is there someway to convert a json file to a tajo table?
>>>> Thanks!
>>>>
>>>
>>

Mime
View raw message