Return-Path: X-Original-To: apmail-hadoop-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-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 ECE8718064 for ; Tue, 27 Oct 2015 21:57:45 +0000 (UTC) Received: (qmail 50117 invoked by uid 500); 27 Oct 2015 21:57:40 -0000 Delivered-To: apmail-hadoop-user-archive@hadoop.apache.org Received: (qmail 49950 invoked by uid 500); 27 Oct 2015 21:57:39 -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 49617 invoked by uid 99); 27 Oct 2015 21:57:39 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Oct 2015 21:57:39 +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 31335C09DF for ; Tue, 27 Oct 2015 21:57:39 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-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: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id PcTsV2CzDh6L for ; Tue, 27 Oct 2015 21:57:28 +0000 (UTC) Received: from mail-ob0-f176.google.com (mail-ob0-f176.google.com [209.85.214.176]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 0274323057 for ; Tue, 27 Oct 2015 21:57:28 +0000 (UTC) Received: by obbwb3 with SMTP id wb3so183769375obb.0 for ; Tue, 27 Oct 2015 14:57:27 -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=dp2z/Hxhr5LFiyyxhqRmvYOEunrQWDscJpz4pY53TVs=; b=05TY1emDTcd9oAxXucRHEoOQo3A/z1TqinHaDLN2PNnImuMPSlUZBL+UfiVo2IfnT+ 3NPFzSYtW/j/vqmpAPRligI93Oy0b5wbt0rb1LAi6MbYj1fL7BXi9hp8vW3wIn9BFlZj dIq5HeE8cmvPNnL/MvaoKCii4blu0CyedWcMj4cc1YY0Pd7e8daFcY+H2uV5H7x8mq2O mx3cEQkyfs9YMMMlJaM3QmXsOIQCrWCJOlcT8o55GElfDepkxKLakqHFIMe32kGPsjnC fOojXQ4pYq6bENLEu2l0KHBwaI8Tl1Fvn0PuRTVTPkh0NCrqcSt43JtNKv3p66+0iWm1 dx9Q== MIME-Version: 1.0 X-Received: by 10.60.144.231 with SMTP id sp7mr31689084oeb.7.1445983047314; Tue, 27 Oct 2015 14:57:27 -0700 (PDT) Received: by 10.202.68.197 with HTTP; Tue, 27 Oct 2015 14:57:27 -0700 (PDT) Date: Tue, 27 Oct 2015 14:57:27 -0700 Message-ID: Subject: hive showing SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate' From: Kumar Jayapal To: user@hadoop.apache.org Content-Type: multipart/alternative; boundary=047d7b47225ee2f45e05231d2994 --047d7b47225ee2f45e05231d2994 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 --047d7b47225ee2f45e05231d2994 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 com= piling statement: FAILED: SemanticException [Error 10002]: Line 3:21 Invali= d column reference 'mbdate'

<= /font>
Here is the query :
select =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 items a
JOIN ivsdays d
O= N a.mbdate =3D d.cldatei
Join ivsref r
ON r.company =3D a.mbcmpy
AND r.warehouse =3D a.= mbwhse=C2=A0
AND r.itemnumber =3D a.mbitem

WHERE
<= div style=3D"color:rgb(185,74,72)">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=A0<= /span>I had checked mbdate = column is present in the table.



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 TExecuteStatementReq(confOverlay= =3D{}, sessionHandle=3DTSessionHandle(sessionId=3DTHandleIdentifier(secret= =3D'L1:\x9c3KB\x94\xaf\x8c\xfa\x8d\x98\x97\xe1Q', guid=3D'+o\x0= 0\xe8\xc5\x12C\xab\xbb\xb5KV\xe0\xf5\x93\xc9')), runAsync=3DTrue, state= ment=3D'select =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 T= ODAY_LY\n\nFROM tlog.item_detail a\nJOIN Adv_analytics.ivsdays d\nON a.mbda= te =3D d.cldatei\nJoin adv_analytics.ivsref r\nON r.company =3D a.mbcmpy\nA= ND r.warehouse =3D a.mbwhse \nAND r.itemnumber =3D a.mbitem\n\n\nWHERE\na.m= bcmpy =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'):
TExe= cuteStatementResp(status=3DTStatus(errorCode=3D10002, errorMessage=3D"= Error while compiling statement: FAILED: SemanticException [Error 10002]: L= ine 3:21 Invalid column reference 'mbdate'", sqlState=3D'4= 2000', infoMessages=3D["*org.apache.hive.service.cli.HiveSQLExcept= ion:Error while compiling statement: FAILED: SemanticException [Error 10002= ]: Line 3:21 Invalid column reference 'mbdate':17:16", 'or= g.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.SQLO= peration:runInternal:SQLOperation.java:171', 'org.apache.hive.servi= ce.cli.operation.Operation:run:Operation.java:257', 'org.apache.hiv= e.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionI= mpl.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:Thrif= tCLIService.java:490', 'org.apache.hive.service.cli.thrift.TCLIServ= ice$Processor$ExecuteStatement:getResult:TCLIService.java:1313', 'o= rg.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:ge= tResult:TCLIService.java:1298', 'org.apache.thrift.ProcessFunction:= process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor= :process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSe= tIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.a= pache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.j= ava:285', 'java.util.concurrent.ThreadPoolExecutor:runWorker:Thread= PoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$W= orker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Threa= d.java:745', "*org.apache.hadoop.hive.ql.parse.SemanticException:L= ine 3:21 Invalid column reference 'mbdate':32:16", 'org.ap= ache.hadoop.hive.ql.parse.SemanticAnalyzer:genAllExprNodeDesc:SemanticAnaly= zer.java:10299', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:= genExprNodeDesc:SemanticAnalyzer.java:10247', 'org.apache.hadoop.hi= ve.ql.parse.SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.java:3720',= 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genSelectPlan:Semant= icAnalyzer.java:3499', 'org.apache.hadoop.hive.ql.parse.SemanticAna= lyzer:genPostGroupByBodyPlan:SemanticAnalyzer.java:8761', 'org.apac= he.hadoop.hive.ql.parse.SemanticAnalyzer:genBodyPlan:SemanticAnalyzer.java:= 8716', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPlan:Se= manticAnalyzer.java:9573', 'org.apache.hadoop.hive.ql.parse.Semanti= cAnalyzer:genPlan:SemanticAnalyzer.java:9466', 'org.apache.hadoop.h= ive.ql.parse.SemanticAnalyzer:genOPTree:SemanticAnalyzer.java:9902', &#= 39;org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:Semanti= cAnalyzer.java:9913', 'org.apache.hadoop.hive.ql.parse.SemanticAnal= yzer:analyzeInternal:SemanticAnalyzer.java:9830', 'org.apache.hadoo= p.hive.ql.parse.BaseSemanticAnalyzer:analyze:BaseSemanticAnalyzer.java:222&= #39;, 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:422', &= #39;org.apache.hadoop.hive.ql.Driver:compile:Driver.java:306', 'org= .apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1111', 'o= rg.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1105', &#= 39;org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.= java:100'], statusCode=3D3), operationHandle=3DNone)
Tracebac= k (most recent call last):
=C2=A0 File "/opt/cloudera/parcel= s/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/apps/beeswax/src/beeswax/server/db= ms.py", line 450, in execute_and_watch
=C2=A0 =C2=A0 handle = =3D self.client.query(query, query_history.statement_number)
=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 866, in qu= ery
=C2=A0 =C2=A0 return self._client.execute_async_query(query, = statement)
=C2=A0 File "/opt/cloudera/parcels/CDH-5.4.5-1.cd= h5.4.5.p1037.741/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.p= y", line 669, in execute_async_query
=C2=A0 =C2=A0 return se= lf.execute_async_statement(statement=3Dquery_statement, confOverlay=3Dconfi= guration)
=C2=A0 File "/opt/cloudera/parcels/CDH-5.4.5-1.cdh= 5.4.5.p1037.741/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py= ", line 687, in execute_async_statement
=C2=A0 =C2=A0 res = =3D self.call(self._client.ExecuteStatement, req)
=C2=A0 File &qu= ot;/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1037.741/lib/hue/apps/beeswa= x/src/beeswax/server/hive_server2_lib.py", line 593, in call
=C2=A0 =C2=A0 raise QueryServerException(Exception('Bad status for req= uest %s:\n%s' % (req, res)), message=3Dmessage)
QueryServerEx= ception: Bad status for request TExecuteStatementReq(confOverlay=3D{}, sess= ionHandle=3DTSessionHandle(sessionId=3DTHandleIdentifier(secret=3D'L1:\= x9c3KB\x94\xaf\x8c\xfa\x8d\x98\x97\xe1Q', guid=3D'+o\x00\xe8\xc5\x1= 2C\xab\xbb\xb5KV\xe0\xf5\x93\xc9')), runAsync=3DTrue, statement=3D'= select =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\nF= ROM tlog.item_detail a\nJOIN Adv_analytics.ivsdays d\nON a.mbdate =3D d.cld= atei\nJoin adv_analytics.ivsref r\nON r.company =3D a.mbcmpy\nAND r.warehou= se =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'):
TExecuteStatemen= tResp(status=3DTStatus(errorCode=3D10002, errorMessage=3D"Error while = compiling statement: FAILED: SemanticException [Error 10002]: Line 3:21 Inv= alid column reference 'mbdate'", sqlState=3D'42000', i= nfoMessages=3D["*org.apache.hive.service.cli.HiveSQLException:Error wh= ile compiling statement: FAILED: SemanticException [Error 10002]: Line 3:21= Invalid column reference 'mbdate':17:16", 'org.apache.hiv= e.service.cli.operation.Operation:toSQLException:Operation.java:315', &= #39;org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation= .java:102', 'org.apache.hive.service.cli.operation.SQLOperation:run= Internal:SQLOperation.java:171', 'org.apache.hive.service.cli.opera= tion.Operation:run:Operation.java:257', 'org.apache.hive.service.cl= i.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:398= ', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStat= ementAsync: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$Processo= r$ExecuteStatement:getResult:TCLIService.java:1313', 'org.apache.hi= ve.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLI= Service.java:1298', 'org.apache.thrift.ProcessFunction:process:Proc= essFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBa= seProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressPr= ocessor: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:Th= readPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745&#= 39;, "*org.apache.hadoop.hive.ql.parse.SemanticException:Line 3:21 Inv= alid column reference 'mbdate':32:16", 'org.apache.hadoop.= hive.ql.parse.SemanticAnalyzer:genAllExprNodeDesc:SemanticAnalyzer.java:102= 99', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genExprNodeD= esc:SemanticAnalyzer.java:10247', 'org.apache.hadoop.hive.ql.parse.= SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.java:3720', 'org.ap= ache.hadoop.hive.ql.parse.SemanticAnalyzer:genSelectPlan:SemanticAnalyzer.j= ava:3499', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPos= tGroupByBodyPlan:SemanticAnalyzer.java:8761', 'org.apache.hadoop.hi= ve.ql.parse.SemanticAnalyzer:genBodyPlan:SemanticAnalyzer.java:8716', &= #39;org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genPlan:SemanticAnalyz= er.java:9573', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:ge= nPlan:SemanticAnalyzer.java:9466', 'org.apache.hadoop.hive.ql.parse= .SemanticAnalyzer:genOPTree:SemanticAnalyzer.java:9902', 'org.apach= e.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.ja= va:9913', 'org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyze= Internal:SemanticAnalyzer.java:9830', 'org.apache.hadoop.hive.ql.pa= rse.BaseSemanticAnalyzer:analyze:BaseSemanticAnalyzer.java:222', 'o= rg.apache.hadoop.hive.ql.Driver:compile:Driver.java:422', 'org.apac= he.hadoop.hive.ql.Driver:compile:Driver.java:306', 'org.apache.hado= op.hive.ql.Driver:compileInternal:Driver.java:1111', 'org.apache.ha= doop.hive.ql.Driver:compileAndRespond:Driver.java:1105', 'org.apach= e.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:100'= ;], statusCode=3D3), operationHandle=3DNone)






Thanks
Ja= y
--047d7b47225ee2f45e05231d2994--