Return-Path: Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org Received: (qmail 23209 invoked from network); 20 Sep 2010 09:45:42 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 20 Sep 2010 09:45:42 -0000 Received: (qmail 17504 invoked by uid 500); 20 Sep 2010 09:45:42 -0000 Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org Received: (qmail 17196 invoked by uid 500); 20 Sep 2010 09:45:39 -0000 Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-user@hadoop.apache.org Delivered-To: mailing list hive-user@hadoop.apache.org Received: (qmail 17188 invoked by uid 99); 20 Sep 2010 09:45:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Sep 2010 09:45:38 +0000 X-ASF-Spam-Status: No, hits=4.4 required=10.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of liulei412@gmail.com designates 209.85.161.176 as permitted sender) Received: from [209.85.161.176] (HELO mail-gx0-f176.google.com) (209.85.161.176) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Sep 2010 09:45:32 +0000 Received: by gxk7 with SMTP id 7so1954290gxk.35 for ; Mon, 20 Sep 2010 02:45:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=D4jYyk/6xvHLKGkdXYl1HUKpuV8mh0CVuWxe3HfoZ+o=; b=ccDymQumuenZTLCGHf/jUhzGX0jIsoMGdZW+WXOltV0joFjPnrjPVX3JveEpFjjVxb Y4i2lFXv94Qhxqy10su0fG4WFfqNzQQwT0V4870GN9B16pwAAFtFikk5exPvHNEonUOR +RIXv/9Xh3Eo2ziGfVo80lvswRzH6foRdc4yw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=hf5MILTKA0OxVvLZW9Uj/5yyBpN6qRjUG5JvNTNfaukA7yZsEu+7V/NW5j8EhGDViK sqr/LAa/nRO8e4qwGB/PtS/gF1pAFiv9qMQSuU88zqGTuNhjrxTsE7YRITaA8M9SgFG3 4hF+WIFFB8srG5xyxFX1jpCqjyvW6QK7+Nhog= MIME-Version: 1.0 Received: by 10.150.217.6 with SMTP id p6mr8538571ybg.445.1284975911361; Mon, 20 Sep 2010 02:45:11 -0700 (PDT) Received: by 10.150.67.18 with HTTP; Mon, 20 Sep 2010 02:45:11 -0700 (PDT) Date: Mon, 20 Sep 2010 17:45:11 +0800 Message-ID: Subject: Virtual Columns error From: lei liu To: hive-user@hadoop.apache.org Content-Type: multipart/alternative; boundary=000e0cd4026cbde00f0490adc4b3 --000e0cd4026cbde00f0490adc4b3 Content-Type: text/plain; charset=ISO-8859-1 I use hive0.6 version and execute 'select INPUT_FILE_NAME, BLOCK_OFFSET_INSIDE_FILE from person1' statement, hive0.6 throws below error: FAILED: Error in semantic analysis: line 1:7 Invalid Table Alias or Column Reference INPUT_FILE_NAME error. Don't hive0.6 support virtual columns? --000e0cd4026cbde00f0490adc4b3 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I use hive0.6 version and=A0 execute 'select INPUT_FILE_NAME,=A0 BLOCK_= OFFSET_INSIDE_FILE from person1' statement,=A0 hive0.6 throws below err= or:
FAILED: Error in semantic analysis: line 1:7 Invalid Table Alias or = Column Reference INPUT_FILE_NAME error.

Don't hive0.6 support virtual columns?


--000e0cd4026cbde00f0490adc4b3--