Return-Path: X-Original-To: apmail-tajo-user-archive@minotaur.apache.org Delivered-To: apmail-tajo-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D666817F81 for ; Thu, 1 Oct 2015 17:11:37 +0000 (UTC) Received: (qmail 69529 invoked by uid 500); 1 Oct 2015 17:11:37 -0000 Delivered-To: apmail-tajo-user-archive@tajo.apache.org Received: (qmail 69492 invoked by uid 500); 1 Oct 2015 17:11:37 -0000 Mailing-List: contact user-help@tajo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@tajo.apache.org Delivered-To: mailing list user@tajo.apache.org Received: (qmail 69482 invoked by uid 99); 1 Oct 2015 17:11:37 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Oct 2015 17:11:37 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id DA479C01D9 for ; Thu, 1 Oct 2015 17:11:36 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.88 X-Spam-Level: ** X-Spam-Status: No, score=2.88 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id pgAi35REFLIS for ; Thu, 1 Oct 2015 17:11:31 +0000 (UTC) Received: from mail-vk0-f42.google.com (mail-vk0-f42.google.com [209.85.213.42]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 3B2F742F8E for ; Thu, 1 Oct 2015 17:11:31 +0000 (UTC) Received: by vkao3 with SMTP id o3so44446657vka.2 for ; Thu, 01 Oct 2015 10:11:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :content-type; bh=cx449XhHe0jAbQdnx30J1FWbSeOxp2HntUA42TKuaKw=; b=pIqPehQHWB1U/Kjz2CYCELUxnm+ozjF/WE8nVIzhjA+oRg93Ifr1PGmUg5Hkc7HvmA bKB1RIqhIvYNnyuPDXVj3gJt5+lPYSGy3e1ZGs35ClEWhWXyivLnZVobhzgnQLQISb6E GZ9rm/98UiIAH+iV+wutwL7qxYP8Nc2LM96rUyGtw/yFAvZe4N+If8ONLuk4l2k/ZgkO vCXvO7//cQTuxKD+6L3cLhkmYuSDtWvxgv/xCR6mY6ot18utPbP8iS3zurw86LrH8wSf Lm6Q04r2Rmgv34y+kaP4lwt4QPhyNGInR1sSZL9AhmLHu6JVVI/9AgtwRjhh2F7l30M/ ylWg== X-Received: by 10.31.162.70 with SMTP id l67mr7321380vke.97.1443719484739; Thu, 01 Oct 2015 10:11:24 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Jihoon Son Date: Thu, 01 Oct 2015 17:11:15 +0000 Message-ID: Subject: Re: JSON table To: user@tajo.apache.org Content-Type: multipart/alternative; boundary=001a1143f8600b168205210e2329 --001a1143f8600b168205210e2329 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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=EB=85=84 10=EC=9B=94 1=EC=9D=BC (=EB=AA=A9) =EC=98=A4=ED=9B=84 8:03, J= ihoon Son =EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1: > 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=EB=85=84 10=EC=9B=94 1=EC=9D=BC (=EB=AA=A9) =EC=98=A4=ED=9B=84 7:50,= Odin Guillermo Caudillo Gallegos > odin.guillermo@gmail.com>=EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1: > > 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 : >> >>> 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-wa= rehouse-for-big-data >>> >>> Thanks, >>> Jihoon >>> >>> 2015=EB=85=84 10=EC=9B=94 2=EC=9D=BC (=EA=B8=88) =EC=98=A4=EC=A0=84 12:= 22, Odin Guillermo Caudillo Gallegos < >>> odin.guillermo@gmail.com>=EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1: >>> >>>> Hi, is there someway to convert a json file to a tajo table? >>>> Thanks! >>>> >>> >> --001a1143f8600b168205210e2329 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 functio= ns to retrieve json fields are listed in our document.)
So, I recommend = to use 0.11.
2015=EB=85=84 = 10=EC=9B=94 1=EC=9D=BC (=EB=AA=A9) =EC=98=A4=ED=9B=84 8:03, Jihoon Son <= ghoonson@gmail.com>=EB=8B=98= =EC=9D=B4 =EC=9E=91=EC=84=B1:
Hi, which version of tajo are you using? That star notation is newly supported from 0.11.
We are currently test= ing 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,
Jih= oon

2015=EB=85=84 10=EC=9B=94 1=EC=9D=BC (=EB=AA=A9) =EC=98=A4=ED=9B= =84 7:50, Odin Guillermo Caudillo Gallegos
odin.guillermo@gmail.com>=EB=8B=98= =EC=9D=B4 =EC=9E=91=EC=84=B1:

Hi , i just tried to create the = table like the example on the slide, but it's giving me an error:
<= div>CREATE EXTERNAL TABLE jsonTable (*) USING json Location 'hdfs://had= oopMaster:9000/InputJson.json';
ERROR: syntax error at or nea= r '*'

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 fil= e. Instead, you can create a tajo table for it.
You have two choic= es.
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-bi= g-data

Thanks,
Jihoon

2015=EB=85=84 10=EC=9B=94 2=EC=9D=BC (= =EA=B8=88) =EC=98=A4=EC=A0=84 12:22, Odin Guillermo Caudillo Gallegos <<= a href=3D"mailto:odin.guillermo@gmail.com" target=3D"_blank">odin.guillermo= @gmail.com>=EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1:
Hi, is there someway to conver= t a json file to a tajo table?
Thanks!

--001a1143f8600b168205210e2329--