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 8BCD31878C for ; Mon, 5 Oct 2015 17:57:59 +0000 (UTC) Received: (qmail 43733 invoked by uid 500); 5 Oct 2015 17:57:59 -0000 Delivered-To: apmail-tajo-user-archive@tajo.apache.org Received: (qmail 43677 invoked by uid 500); 5 Oct 2015 17:57:59 -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 43667 invoked by uid 99); 5 Oct 2015 17:57:59 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Oct 2015 17:57:59 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id EAC3EC2B7A for ; Mon, 5 Oct 2015 17:57:58 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.879 X-Spam-Level: ** X-Spam-Status: No, score=2.879 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] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id H3U1AlbxTqEA for ; Mon, 5 Oct 2015 17:57:58 +0000 (UTC) Received: from mail-yk0-f179.google.com (mail-yk0-f179.google.com [209.85.160.179]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id A8D4A204DD for ; Mon, 5 Oct 2015 17:57:57 +0000 (UTC) Received: by ykdt18 with SMTP id t18so178841935ykd.3 for ; Mon, 05 Oct 2015 10:57:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=bWJyFQ7nrYR8zoS/88agDWAQY2HrusCJvSQi4PjOdU8=; b=QLW67FdUxpuxpZWQzGKDdr8M+RQy/hT072EgUWHU3UUBnbrzgtV/B14dsm1ccr0aGY pHUX5EO3u76ccxnbqkU0wWUz3lN86A7gr6IjmMPYN4JFNB9koTxQCS7FHEf0Mq3F5oOl TIMABrtjzMcr9/2Q1Egg4tY+RZ2BG4eSA8JOaSP0EPXaC4zW56+CK3HhLElxdEfFnsED EBAPIRpW5INo7p9cF3wXbIugtBZm2YEesVH7Q3joKXiKRMxwg1AMF/MIVfgzauHzB869 cToXA4RW2Xbpk9lHw0tSYcm+LeH8l78ErqN4tSks5YtdK7/rOKeEsvXNzNux9FqKJ3GZ c22Q== MIME-Version: 1.0 X-Received: by 10.129.95.10 with SMTP id t10mr25028834ywb.100.1444067876758; Mon, 05 Oct 2015 10:57:56 -0700 (PDT) Received: by 10.37.59.145 with HTTP; Mon, 5 Oct 2015 10:57:56 -0700 (PDT) Date: Mon, 5 Oct 2015 12:57:56 -0500 Message-ID: Subject: Json Query From: Odin Guillermo Caudillo Gallegos To: user@tajo.apache.org Content-Type: multipart/alternative; boundary=001a1147f92ed36f6e05215f40d8 --001a1147f92ed36f6e05215f40d8 Content-Type: text/plain; charset=UTF-8 Hi. I have a schemaless table based on json files. If i do a query like the following: select dj."MyField" from jsontable dj; it gives me the error "ERROR: internal error: Columns projected from default.jsondigilant is not found." So i can't use alias if i'm using a schemaless table? Thanks! --001a1147f92ed36f6e05215f40d8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi.
I have a schemaless table based on json files.
If i do a query like the following:

select = dj."MyField" from jsontable dj;
it gives me the error &= quot;ERROR: internal error: Columns projected from default.jsondigilant is = not found."
So i can't use alias if i'm using a sche= maless table?
Thanks!
--001a1147f92ed36f6e05215f40d8--