Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2D44D1116E for ; Tue, 16 Sep 2014 06:29:21 +0000 (UTC) Received: (qmail 83714 invoked by uid 500); 16 Sep 2014 06:29:19 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 83641 invoked by uid 500); 16 Sep 2014 06:29:19 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 83631 invoked by uid 99); 16 Sep 2014 06:29:19 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Sep 2014 06:29:19 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gctsakthi@yahoo.com designates 106.10.151.164 as permitted sender) Received: from [106.10.151.164] (HELO nm29-vm5.bullet.mail.sg3.yahoo.com) (106.10.151.164) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Sep 2014 06:29:13 +0000 Received: from [106.10.166.125] by nm29.bullet.mail.sg3.yahoo.com with NNFMP; 16 Sep 2014 06:28:50 -0000 Received: from [106.10.151.235] by tm14.bullet.mail.sg3.yahoo.com with NNFMP; 16 Sep 2014 06:28:50 -0000 Received: from [127.0.0.1] by omp1019.mail.sg3.yahoo.com with NNFMP; 16 Sep 2014 06:28:50 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 471783.2591.bm@omp1019.mail.sg3.yahoo.com Received: (qmail 26255 invoked by uid 60001); 16 Sep 2014 06:28:50 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1410848930; bh=Hw4W2YxR1sewwyI6Dx0raN8zpgWHI4zu8O73xZfUce0=; h=References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=t6bTvLLnrqgmHHEa/XTx3qqKgiGlTiEZgDt6cGX8/WCSZON2AWkp1/KU3Mmo8XcWjOpTwAPB8vU8tg2iksC+REkgQS1muN6pEZGNDRNrm7VhJcqnSbdYwA4itb/kHfUWfJa1voYzz5cW9BVt58Ls/cA0wu9lqDh4YfFjNBGZFz0= X-YMail-OSG: 7cRVzpAVM1mczCBoqrBEqxwyyWfzHkpFgyWwNZ.dG5KIlN4 EqqrRfBUr5Oa0Jzo17E.pQaF5TGhvZa.XsejqpsbNQ6dr7wEct4x.LI0aFz0 02IU.N46LfGFMEHTozM6RUbve8hnaweCEOyzih2fl0UPQyJ.DXxClrhf1rGE Z8x0hAIA2YNVEtYqEBD9JS0GqBCV88xEJX75GUSXJkvL605TxQgCZlk50XNs QXqy4gDI45CVyHz.SI6QXkWs14S67LKLkwfCDjaoimZkBYZmrWX25EAR8EpE tc.rI6uvlbGKKd8LWPDdbKMLuDgNSItYfZAbL0DxcHo_vjqFu0Td7LDkhb1X juWl1GVX.IMEs8MU.ewct4INfGNbAK_lFgH0t4RVVKdbimb9d2wAN4hYp2fz 7YHp.z3X4j78DZjN.KSx6k_FOSzhJnXTo7U3PftBTdYMArDjPAFudUnDeVP8 3kvJ3h.cZzrAdeDrL8t8vE0Qpv9fmSTfDpL6DNmCSRY6mDXSIgL_9UJF3iMN sNN1lJ9jHkxBNCWsmdx_5EKNfCIt21CiUBV51EKhOEdXUF4BKeRwPJ1zdLOJ ZA9sjZd9GwL.hBaJLuHSL2P9d4xw9ABNiK35ZkP4QayLMeBMESAR.CDqGPsV GePgigJxcddq51g-- Received: from [202.76.243.10] by web190305.mail.sg3.yahoo.com via HTTP; Tue, 16 Sep 2014 14:28:50 SGT X-Rocket-MIMEInfo: 002.001,CgoKCkhpIEhpdmUgZGV2ZWxvcGVycywKSSBhbSBuZXcgdG8gaGl2ZS4gWWVzdGVyZGF5IGkgaW5zdGFsbGVkIGFwYWNoZSBoaXZlLTAuOS4wIGFuZCBzdGFydCBleGVjdXRpbmcgc29tZSBiYXNpY3MgY29tbWFuZCBhbmQgaSBmb3VuZCBvbmUgYWJub3JtYWwgYmVoYXZpb3IgaW4gc2VsZWN0KiBjb21tYW5kLiAgSW4gc2VsZWN0IHN0YXRlbWVudCBhZnRlciAqIGFueSByYW5kb20gY2hhcmFjdGVycyBhcmUgYWxsb3dlZCBpbiBoaXZlIGJ1dCBpbiBSREJNUyBpdHMgbm90IGFsbG93ZWQuICBJIGFtIG5vdCBzdXIBMAEBAQE- X-Mailer: YahooMailWebService/0.8.203.696 References: <1410848418.2807.YahooMailNeo@web190306.mail.sg3.yahoo.com> Message-ID: <1410848930.77557.YahooMailNeo@web190305.mail.sg3.yahoo.com> Date: Tue, 16 Sep 2014 14:28:50 +0800 From: Sivasakthi Reply-To: Sivasakthi Subject: Hive: Select * command not working similar to RDBMS To: "user@hive.apache.org" In-Reply-To: <1410848418.2807.YahooMailNeo@web190306.mail.sg3.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1555628092-1307582340-1410848930=:77557" X-Virus-Checked: Checked by ClamAV on apache.org --1555628092-1307582340-1410848930=:77557 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable =0A=0A=0A=0AHi Hive developers,=0AI am new to hive. Yesterday i installed a= pache hive-0.9.0 and start executing some basics command and i found one ab= normal behavior in select* command. In select statement after * any random= characters are allowed in hive but in RDBMS its not allowed. I am not sur= e its expected behavior or bug in hive. Could some please confirm?=0A=0A=0A= In the below query "abcdef" is random characters.=0A=0AIn RDBMS(oracle): = =0A=0Aselect *abcdef from mytable;=0AOutput: =0AERROR prepare() failed with= : ORA-00923: FROM keyword not found where expected=0A=0AIn Hive:=0Aselect *= abcdef from mytable;=0AOutput: =0A=0AQuery worked fine and display all the = records of mytable.=0A=0AThanks=0ASiva.. --1555628092-1307582340-1410848930=:77557 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable



Hi Hiv= e developers,
I am new = to hive. Yesterday i installed apache hive-0.9.0 and start executing some b= asics command and i found one abnormal behavior in select* command.  In select statement = after * any random characters are allowed in hive but in RDBMS its not allo= wed.  I am not sure its expected behavior or bug in hive. Could some p= lease confirm?

In th= e below query "abcdef" is random characters.

In RDBMS(or= acle):
<= /div>
select *abcd= ef from mytable;
Output:
ERROR prepare() fai= led with: ORA-00923: FROM keyword not found where expected<= /span>

In Hive:<= /span>
selec= t *abcdef from mytable;
Output:
Query worked fine and display all the records of mytab= le.

Thanks
Siva..=


--1555628092-1307582340-1410848930=:77557--