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! >> >
