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 <[email protected]>님이 작성:
> 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 > [email protected]>님이 작성: > > 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 <[email protected]>: >> >>> 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 < >>> [email protected]>님이 작성: >>> >>>> Hi, is there someway to convert a json file to a tajo table? >>>> Thanks! >>>> >>> >>
