Return-Path: X-Original-To: apmail-hadoop-common-user-archive@www.apache.org Delivered-To: apmail-hadoop-common-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 2754E186C9 for ; Wed, 28 Oct 2015 14:52:55 +0000 (UTC) Received: (qmail 56540 invoked by uid 500); 28 Oct 2015 14:52:48 -0000 Delivered-To: apmail-hadoop-common-user-archive@hadoop.apache.org Received: (qmail 56429 invoked by uid 500); 28 Oct 2015 14:52:48 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 56419 invoked by uid 99); 28 Oct 2015 14:52:48 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Oct 2015 14:52:48 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 07D081A29CD for ; Wed, 28 Oct 2015 14:52:48 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.15 X-Spam-Level: *** X-Spam-Status: No, score=3.15 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-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 (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id qgu5iNre3UZW for ; Wed, 28 Oct 2015 14:52:36 +0000 (UTC) Received: from mail-ob0-f176.google.com (mail-ob0-f176.google.com [209.85.214.176]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id EEDB520604 for ; Wed, 28 Oct 2015 14:52:35 +0000 (UTC) Received: by obcqt19 with SMTP id qt19so8009796obc.3 for ; Wed, 28 Oct 2015 07:52:28 -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=bm18HOi9O+CzrP5f2sITSq22ki1I2iauHtbPzCU9u1U=; b=WnkoqTnxXm6f2TvrOShDf+GY/CS8qVsliY2rvxYoohN4Hwz0V0oIKFqDyqu4yeHzgu HDH/0SyrHr3cEkPEhMPkitAURvUvYQHZqGBwKRJhwtFUHSaml10buo+jfgtGzZjYxvCI ursNAt24ipuJqkSkmSQdqRKpFeSqLuoec2KbEi04jheLLBIJC95xrdBGSb9TObE7cnw6 DEEbhu5qqIfh34zkHLHkNEW7yaIMQSmH32lyeD4CetgxPGAvjx1501QHf7K6grGC0oTN PkI1IWH7y9I+4irKVCZj0IoUWhTXqUbliva3/bbMKBoe+F3L2zOnj64d5QXPNzpOwQPX 2k9Q== MIME-Version: 1.0 X-Received: by 10.60.123.2 with SMTP id lw2mr34817382oeb.2.1446043948742; Wed, 28 Oct 2015 07:52:28 -0700 (PDT) Received: by 10.202.68.197 with HTTP; Wed, 28 Oct 2015 07:52:28 -0700 (PDT) Date: Wed, 28 Oct 2015 07:52:28 -0700 Message-ID: Subject: Hive showing SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate From: Kumar Jayapal To: Hue-Users , user@hadoop.apache.org Content-Type: multipart/alternative; boundary=047d7b5d4240e4fe7105232b57a3 --047d7b5d4240e4fe7105232b57a3 Content-Type: text/plain; charset=UTF-8 Hello, Can some please help. When I execute hive query with as case statement I get this error " Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate' Here is the query : select a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, (CASE WHEN to_date(a.mbdate) = d.today_ly THEN (a.mbdsun) END) as TODAY_LY FROM items a JOIN ivsdays d ON a.mbdate = d.cldatei Join ivsref r ON r.company = a.mbcmpy AND r.warehouse = a.mbwhse AND r.itemnumber = a.mbitem WHERE a.mbcmpy = 1 AND a.mbdept = 20 group by a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, Today_ly ORDER by 1,2,3,4,5 Same query work in Impala. I had checked mbdate column is present in the table. Here is the hue log : [27/Oct/2015 14:53:21 -0700] dbms ERROR Bad status for request TExecuteStatementReq(confOverlay={}, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret='L1:\x9c3KB\x94\xaf\x8c\xfa\x8d\x98\x97\xe1Q', guid='+o\x00\xe8\xc5\x12C\xab\xbb\xb5KV\xe0\xf5\x93\xc9')), runAsync=True, statement='select a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, \n\n(CASE WHEN to_date(a.mbdate) = d.today_ly THEN (a.mbdsun) END) as TODAY_LY\n\nFROM tlog.item_detail a\nJOIN Adv_analytics.ivsdays d\nON a.mbdate = d.cldatei\nJoin adv_analytics.ivsref r\nON r.company = a.mbcmpy\nAND r.warehouse = a.mbwhse \nAND r.itemnumber = a.mbitem\n\n\nWHERE\na.mbcmpy = 1\nAND a.mbdept = 20\n\n\ngroup by \n a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, Today_ly\n\nORDER by\n1,2,3,4,5'): TExecuteStatementResp(status=TStatus(errorCode=10002, errorMessage="Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate'", sqlState='42000', infoMessages=["*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate':17:16", 'org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:315', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:102', 'org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:171', 'org.apache.hive.service.cli.operation.Operation:run:Operation.java:257', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:398', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementAsync:HiveSessionImpl.java:385', 'org.apache.hive.service.cli.CLIService:executeStatementAsync:CLIService.java:258', 'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:490', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1313', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1298', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745', "*org.apache.hadoop.hive.ql.parse.SemanticException:Line 3:21 Invalid column reference 'mbdate':32:16", 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genAllExprNodeDesc:SemanticAnalyzer.java:10299', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genExprNodeDesc:SemanticAnalyzer.java:10247', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.java:3720', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.java:3499', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPostGroupByBodyPlan:SemanticAnalyzer.java:8761', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genBodyPlan:SemanticAnalyzer.java:8716', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPlan:SemanticAnalyzer.java:9573', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPlan:SemanticAnalyzer.java:9466', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genOPTree:SemanticAnalyzer.java:9902', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:9913', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:9830', 'org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer:analyze:BaseSemanticAnalyzer.java:222', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:422', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:306', 'org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1111', 'org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1105', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:100'], statusCode=3), operationHandle=None) Traceback (most recent call last): File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 450, in execute_and_watch handle = self.client.query(query, query_history.statement_number) File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 866, in query return self._client.execute_async_query(query, statement) File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 669, in execute_async_query return self.execute_async_statement(statement=query_statement, confOverlay=configuration) File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 687, in execute_async_statement res = self.call(self._client.ExecuteStatement, req) File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 593, in call raise QueryServerException(Exception('Bad status for request %s:\n%s' % (req, res)), message=message) QueryServerException: Bad status for request TExecuteStatementReq(confOverlay={}, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret='L1:\x9c3KB\x94\xaf\x8c\xfa\x8d\x98\x97\xe1Q', guid='+o\x00\xe8\xc5\x12C\xab\xbb\xb5KV\xe0\xf5\x93\xc9')), runAsync=True, statement='select a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, \n\n(CASE WHEN to_date(a.mbdate) = d.today_ly THEN (a.mbdsun) END) as TODAY_LY\n\nFROM tlog.item_detail a\nJOIN Adv_analytics.ivsdays d\nON a.mbdate = d.cldatei\nJoin adv_analytics.ivsref r\nON r.company = a.mbcmpy\nAND r.warehouse = a.mbwhse \nAND r.itemnumber = a.mbitem\n\n\nWHERE\na.mbcmpy = 1\nAND a.mbdept = 20\n\n\ngroup by \n a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, Today_ly\n\nORDER by\n1,2,3,4,5'): TExecuteStatementResp(status=TStatus(errorCode=10002, errorMessage="Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate'", sqlState='42000', infoMessages=["*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate':17:16", 'org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:315', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:102', 'org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:171', 'org.apache.hive.service.cli.operation.Operation:run:Operation.java:257', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:398', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementAsync:HiveSessionImpl.java:385', 'org.apache.hive.service.cli.CLIService:executeStatementAsync:CLIService.java:258', 'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:490', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1313', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1298', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745', "*org.apache.hadoop.hive.ql.parse.SemanticException:Line 3:21 Invalid column reference 'mbdate':32:16", 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genAllExprNodeDesc:SemanticAnalyzer.java:10299', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genExprNodeDesc:SemanticAnalyzer.java:10247', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.java:3720', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.java:3499', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPostGroupByBodyPlan:SemanticAnalyzer.java:8761', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genBodyPlan:SemanticAnalyzer.java:8716', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPlan:SemanticAnalyzer.java:9573', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPlan:SemanticAnalyzer.java:9466', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genOPTree:SemanticAnalyzer.java:9902', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:9913', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:9830', 'org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer:analyze:BaseSemanticAnalyzer.java:222', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:422', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:306', 'org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1111', 'org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1105', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:100'], statusCode=3), operationHandle=None) Thanks Jay --047d7b5d4240e4fe7105232b57a3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,


Can some please h= elp. When I execute hive query with as case statement I get this error &quo= t;=C2=A0Error while compiling stat= ement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid column re= ference 'mbdate'

Here is the query :
selec= t =C2=A0a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem,=C2=A0
=
(CASE WHEN to_date(a.mbdate) =3D =C2=A0d.today_ly= =C2=A0THEN (a.mbdsun) END) as TODAY_LY
FROM item= s a
JOIN ivsdays d
ON a.mbdate = =3D d.cldatei
Join ivsref r
O= N r.company =3D a.mbcmpy
AND r.warehouse =3D a.mbwhse= =C2=A0
AND r.itemnumber =3D a.mbitem

WHERE
a.mbcmpy =3D 1
AND a.mbdept =3D 20

group by=C2=A0
=C2= =A0 =C2=A0a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, Today_ly

ORDER by
1,2,3,4,5

Same query work in Impala.=C2=A0I had checked mbdate colum= n is present in the table.

<= br>

Here is the hue log :

[27/Oct/2015 14:53:21 -0700] dbms =C2= =A0 =C2=A0 =C2=A0 =C2=A0 ERROR =C2=A0 =C2=A0Bad status for request TExecute= StatementReq(confOverlay=3D{}, sessionHandle=3DTSessionHandle(sessionId=3DT= HandleIdentifier(secret=3D'L1:\x9c3KB\x94\xaf\x8c\xfa\x8d\x98\x97\xe1Q&= #39;, guid=3D'+o\x00\xe8\xc5\x12C\xab\xbb\xb5KV\xe0\xf5\x93\xc9')),= runAsync=3DTrue, statement=3D'select =C2=A0a.mbcmpy, a.mbwhse, a.mbdep= t, a.mbitem, \n\n(CASE WHEN to_date(a.mbdate) =3D =C2=A0d.today_ly =C2=A0TH= EN (a.mbdsun) END) as TODAY_LY\n\nFROM tlog.item_detail a\nJOIN Adv_analyti= cs.ivsdays d\nON a.mbdate =3D d.cldatei\nJoin adv_analytics.ivsref r\nON r.= company =3D a.mbcmpy\nAND r.warehouse =3D a.mbwhse \nAND r.itemnumber =3D a= .mbitem\n\n\nWHERE\na.mbcmpy =3D 1\nAND a.mbdept =3D 20\n\n\ngroup by \n = =C2=A0 a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, Today_ly\n\nORDER by\n1,2,3,= 4,5'):
TExecuteStatementResp(statu= s=3DTStatus(errorCode=3D10002, errorMessage=3D"Error while compiling s= tatement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid column= reference 'mbdate'", sqlState=3D'42000', infoMessages= =3D["*org.apache.hive.service.cli.HiveSQLException:Error while compili= ng statement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid co= lumn reference 'mbdate':17:16", 'org.apache.hive.service.c= li.operation.Operation:toSQLException:Operation.java:315', 'org.apa= che.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:102&#= 39;, 'org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQ= LOperation.java:171', 'org.apache.hive.service.cli.operation.Operat= ion:run:Operation.java:257', 'org.apache.hive.service.cli.session.H= iveSessionImpl:executeStatementInternal:HiveSessionImpl.java:398', '= ;org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementAsync:= HiveSessionImpl.java:385', 'org.apache.hive.service.cli.CLIService:= executeStatementAsync:CLIService.java:258', 'org.apache.hive.servic= e.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:490= 9;, 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteSt= atement:getResult:TCLIService.java:1313', 'org.apache.hive.service.= cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.jav= a:1298', 'org.apache.thrift.ProcessFunction:process:ProcessFunction= .java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor= .java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:pro= cess:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TTh= readPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', 'java= .util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145&= #39;, 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExe= cutor.java:615', 'java.lang.Thread:run:Thread.java:745', "= *org.apache.hadoop.hive.ql.parse.SemanticException:Line 3:21 Invalid column= reference 'mbdate':32:16", 'org.apache.hadoop.hive.ql.par= se.SemanticAnalyzer:genAllExprNodeDesc:SemanticAnalyzer.java:10299', &#= 39;org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genExprNodeDesc:Semanti= cAnalyzer.java:10247', 'org.apache.hadoop.hive.ql.parse.SemanticAna= lyzer:genSelectPlan:SemanticAnalyzer.java:3720', 'org.apache.hadoop= .hive.ql.parse.SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.java:3499= 9;, 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPostGroupByBod= yPlan:SemanticAnalyzer.java:8761', 'org.apache.hadoop.hive.ql.parse= .SemanticAnalyzer:genBodyPlan:SemanticAnalyzer.java:8716', 'org.apa= che.hadoop.hive.ql.parse.SemanticAnalyzer:genPlan:SemanticAnalyzer.java:957= 3', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPlan:Seman= ticAnalyzer.java:9466', 'org.apache.hadoop.hive.ql.parse.SemanticAn= alyzer:genOPTree:SemanticAnalyzer.java:9902', 'org.apache.hadoop.hi= ve.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:9913'= ;, 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:Se= manticAnalyzer.java:9830', 'org.apache.hadoop.hive.ql.parse.BaseSem= anticAnalyzer:analyze:BaseSemanticAnalyzer.java:222', 'org.apache.h= adoop.hive.ql.Driver:compile:Driver.java:422', 'org.apache.hadoop.h= ive.ql.Driver:compile:Driver.java:306', 'org.apache.hadoop.hive.ql.= Driver:compileInternal:Driver.java:1111', 'org.apache.hadoop.hive.q= l.Driver:compileAndRespond:Driver.java:1105', 'org.apache.hive.serv= ice.cli.operation.SQLOperation:prepare:SQLOperation.java:100'], statusC= ode=3D3), operationHandle=3DNone)
Trac= eback (most recent call last):
=C2=A0 = File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/app= s/beeswax/src/beeswax/server/dbms.py", line 450, in execute_and_watch<= /div>
=C2=A0 =C2=A0 handle =3D self.client.q= uery(query, query_history.statement_number)
=C2=A0 File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.74= 1/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 8= 66, in query
=C2=A0 =C2=A0 return self= ._client.execute_async_query(query, statement)
=C2=A0 File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037= .741/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", lin= e 669, in execute_async_query
=C2=A0 = =C2=A0 return self.execute_async_statement(statement=3Dquery_statement, con= fOverlay=3Dconfiguration)
=C2=A0 File = "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/apps/bee= swax/src/beeswax/server/hive_server2_lib.py", line 687, in execute_asy= nc_statement
=C2=A0 =C2=A0 res =3D sel= f.call(self._client.ExecuteStatement, req)
=C2=A0 File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741= /lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 59= 3, in call
=C2=A0 =C2=A0 raise QuerySe= rverException(Exception('Bad status for request %s:\n%s' % (req, re= s)), message=3Dmessage)
QueryServerExc= eption: Bad status for request TExecuteStatementReq(confOverlay=3D{}, sessi= onHandle=3DTSessionHandle(sessionId=3DTHandleIdentifier(secret=3D'L1:\x= 9c3KB\x94\xaf\x8c\xfa\x8d\x98\x97\xe1Q', guid=3D'+o\x00\xe8\xc5\x12= C\xab\xbb\xb5KV\xe0\xf5\x93\xc9')), runAsync=3DTrue, statement=3D's= elect =C2=A0a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, \n\n(CASE WHEN to_date(= a.mbdate) =3D =C2=A0d.today_ly =C2=A0THEN (a.mbdsun) END) as TODAY_LY\n\nFR= OM tlog.item_detail a\nJOIN Adv_analytics.ivsdays d\nON a.mbdate =3D d.clda= tei\nJoin adv_analytics.ivsref r\nON r.company =3D a.mbcmpy\nAND r.warehous= e =3D a.mbwhse \nAND r.itemnumber =3D a.mbitem\n\n\nWHERE\na.mbcmpy =3D 1\n= AND a.mbdept =3D 20\n\n\ngroup by \n =C2=A0 a.mbcmpy, a.mbwhse, a.mbdept, a= .mbitem, Today_ly\n\nORDER by\n1,2,3,4,5'):
TExecuteStatementResp(status=3DTStatus(errorCode=3D10002, errorMe= ssage=3D"Error while compiling statement: FAILED: SemanticException [E= rror 10002]: Line 3:21 Invalid column reference 'mbdate'", sql= State=3D'42000', infoMessages=3D["*org.apache.hive.service.cli= .HiveSQLException:Error while compiling statement: FAILED: SemanticExceptio= n [Error 10002]: Line 3:21 Invalid column reference 'mbdate':17:16&= quot;, 'org.apache.hive.service.cli.operation.Operation:toSQLException:= Operation.java:315', 'org.apache.hive.service.cli.operation.SQLOper= ation:prepare:SQLOperation.java:102', 'org.apache.hive.service.cli.= operation.SQLOperation:runInternal:SQLOperation.java:171', 'org.apa= che.hive.service.cli.operation.Operation:run:Operation.java:257', '= org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInterna= l:HiveSessionImpl.java:398', 'org.apache.hive.service.cli.session.H= iveSessionImpl:executeStatementAsync:HiveSessionImpl.java:385', 'or= g.apache.hive.service.cli.CLIService:executeStatementAsync:CLIService.java:= 258', 'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteS= tatement:ThriftCLIService.java:490', 'org.apache.hive.service.cli.t= hrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:131= 3', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$Execu= teStatement:getResult:TCLIService.java:1298', 'org.apache.thrift.Pr= ocessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.= TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.se= rvice.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56= 9;, 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThre= adPoolServer.java:285', 'java.util.concurrent.ThreadPoolExecutor:ru= nWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.Thread= PoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Th= read:run:Thread.java:745', "*org.apache.hadoop.hive.ql.parse.Seman= ticException:Line 3:21 Invalid column reference 'mbdate':32:16"= ;, 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genAllExprNodeDesc= :SemanticAnalyzer.java:10299', 'org.apache.hadoop.hive.ql.parse.Sem= anticAnalyzer:genExprNodeDesc:SemanticAnalyzer.java:10247', 'org.ap= ache.hadoop.hive.ql.parse.SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.j= ava:3720', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genSel= ectPlan:SemanticAnalyzer.java:3499', 'org.apache.hadoop.hive.ql.par= se.SemanticAnalyzer:genPostGroupByBodyPlan:SemanticAnalyzer.java:8761',= 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genBodyPlan:Semantic= Analyzer.java:8716', 'org.apache.hadoop.hive.ql.parse.SemanticAnaly= zer:genPlan:SemanticAnalyzer.java:9573', 'org.apache.hadoop.hive.ql= .parse.SemanticAnalyzer:genPlan:SemanticAnalyzer.java:9466', 'org.a= pache.hadoop.hive.ql.parse.SemanticAnalyzer:genOPTree:SemanticAnalyzer.java= :9902', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeIn= ternal:SemanticAnalyzer.java:9913', 'org.apache.hadoop.hive.ql.pars= e.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:9830', 'or= g.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer:analyze:BaseSemanticAnal= yzer.java:222', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.ja= va:422', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:306&= #39;, 'org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:111= 1', 'org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java= :1105', 'org.apache.hive.service.cli.operation.SQLOperation:prepare= :SQLOperation.java:100'], statusCode=3D3), operationHandle=3DNone)




=




Thank= s
Jay
--047d7b5d4240e4fe7105232b57a3--