Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8F92918C46 for ; Sat, 23 May 2015 23:48:17 +0000 (UTC) Received: (qmail 11633 invoked by uid 500); 23 May 2015 23:48:17 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 11611 invoked by uid 500); 23 May 2015 23:48:17 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 11600 invoked by uid 99); 23 May 2015 23:48:17 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 May 2015 23:48:17 +0000 Date: Sat, 23 May 2015 23:48:17 +0000 (UTC) From: "Hive QA (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-10811) RelFieldTrimmer throws NoSuchElementException in some cases MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-10811?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1455= 7575#comment-14557575 ]=20 Hive QA commented on HIVE-10811: -------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12735030/HIVE-10811.patch {color:red}ERROR:{color} -1 due to 10 failed/errored test(s), 8971 tests ex= ecuted *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_notexists org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_notexists_h= aving org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udf_crc32 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udf_sha1 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vector_join30 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_explainuser_1 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_explainuser_2 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_null_p= rojection org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_ql_rewrite_gbt= oidx_cbo_2 org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.h= catalog.hbase.TestPigHBaseStorageHandler {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job= /PreCommit-HIVE-TRUNK-Build/4023/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/j= ob/PreCommit-HIVE-TRUNK-Build/4023/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit= -HIVE-TRUNK-Build-4023/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 10 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12735030 - PreCommit-HIVE-TRUNK-Build > RelFieldTrimmer throws NoSuchElementException in some cases > ----------------------------------------------------------- > > Key: HIVE-10811 > URL: https://issues.apache.org/jira/browse/HIVE-10811 > Project: Hive > Issue Type: Bug > Components: CBO > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-10811.patch > > > RelFieldTrimmer runs into NoSuchElementException in some cases. > Stack trace: > {noformat} > Exception in thread "main" java.lang.AssertionError: Internal error: Whil= e invoking method 'public org.apache.calcite.sql2rel.RelFieldTrimmer$TrimRe= sult org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(org.apache.calci= te.rel.core.Sort,org.apache.calcite.util.ImmutableBitSet,java.util.Set)' > =09at org.apache.calcite.util.Util.newInternal(Util.java:743) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:543) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFi= eldTrimmer.java:269) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trim(RelFieldTrimmer.jav= a:175) > =09at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction= .applyPreJoinOrderingTransforms(CalcitePlanner.java:947) > =09at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction= .apply(CalcitePlanner.java:820) > =09at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction= .apply(CalcitePlanner.java:768) > =09at org.apache.calcite.tools.Frameworks$1.apply(Frameworks.java:109) > =09at org.apache.calcite.prepare.CalcitePrepareImpl.perform(CalcitePrepar= eImpl.java:730) > =09at org.apache.calcite.tools.Frameworks.withPrepare(Frameworks.java:145= ) > =09at org.apache.calcite.tools.Frameworks.withPlanner(Frameworks.java:105= ) > =09at org.apache.hadoop.hive.ql.parse.CalcitePlanner.getOptimizedAST(Calc= itePlanner.java:607) > =09at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePla= nner.java:244) > =09at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(Se= manticAnalyzer.java:10048) > =09at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(Calc= itePlanner.java:207) > =09at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSe= manticAnalyzer.java:227) > =09at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:424) > =09at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:308) > =09at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1122) > =09at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1170) > =09at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1059) > =09at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1049) > =09at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java= :213) > =09at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:165) > =09at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:376= ) > =09at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:7= 36) > =09at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681) > =09at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621) > =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp= l.java:57) > =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc= essorImpl.java:43) > =09at java.lang.reflect.Method.invoke(Method.java:606) > =09at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > =09at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > Caused by: java.lang.reflect.InvocationTargetException > =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp= l.java:57) > =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc= essorImpl.java:43) > =09at java.lang.reflect.Method.invoke(Method.java:606) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:536) > =09... 32 more > Caused by: java.lang.AssertionError: Internal error: While invoking metho= d 'public org.apache.calcite.sql2rel.RelFieldTrimmer$TrimResult org.apache.= calcite.sql2rel.RelFieldTrimmer.trimFields(org.apache.calcite.rel.core.Sort= ,org.apache.calcite.util.ImmutableBitSet,java.util.Set)' > =09at org.apache.calcite.util.Util.newInternal(Util.java:743) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:543) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFi= eldTrimmer.java:269) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimme= r.java:210) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimm= er.java:499) > =09... 37 more > Caused by: java.lang.reflect.InvocationTargetException > =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp= l.java:57) > =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc= essorImpl.java:43) > =09at java.lang.reflect.Method.invoke(Method.java:606) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:536) > =09... 40 more > Caused by: java.lang.AssertionError: Internal error: While invoking metho= d 'public org.apache.calcite.sql2rel.RelFieldTrimmer$TrimResult org.apache.= calcite.sql2rel.RelFieldTrimmer.trimFields(org.apache.calcite.rel.core.Proj= ect,org.apache.calcite.util.ImmutableBitSet,java.util.Set)' > =09at org.apache.calcite.util.Util.newInternal(Util.java:743) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:543) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFi= eldTrimmer.java:269) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimme= r.java:210) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimm= er.java:499) > =09... 45 more > Caused by: java.lang.reflect.InvocationTargetException > =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp= l.java:57) > =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc= essorImpl.java:43) > =09at java.lang.reflect.Method.invoke(Method.java:606) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:536) > =09... 48 more > Caused by: java.lang.AssertionError: Internal error: While invoking metho= d 'public org.apache.calcite.sql2rel.RelFieldTrimmer$TrimResult org.apache.= calcite.sql2rel.RelFieldTrimmer.trimFields(org.apache.calcite.rel.core.Aggr= egate,org.apache.calcite.util.ImmutableBitSet,java.util.Set)' > =09at org.apache.calcite.util.Util.newInternal(Util.java:743) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:543) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFi= eldTrimmer.java:269) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimme= r.java:210) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimm= er.java:345) > =09... 53 more > Caused by: java.lang.reflect.InvocationTargetException > =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp= l.java:57) > =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc= essorImpl.java:43) > =09at java.lang.reflect.Method.invoke(Method.java:606) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:536) > =09... 56 more > Caused by: java.lang.AssertionError: Internal error: While invoking metho= d 'public org.apache.calcite.sql2rel.RelFieldTrimmer$TrimResult org.apache.= calcite.sql2rel.RelFieldTrimmer.trimFields(org.apache.calcite.rel.core.Proj= ect,org.apache.calcite.util.ImmutableBitSet,java.util.Set)' > =09at org.apache.calcite.util.Util.newInternal(Util.java:743) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:543) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFi= eldTrimmer.java:269) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimme= r.java:210) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimm= er.java:772) > =09... 61 more > Caused by: java.lang.reflect.InvocationTargetException > =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp= l.java:57) > =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc= essorImpl.java:43) > =09at java.lang.reflect.Method.invoke(Method.java:606) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:536) > =09... 64 more > Caused by: java.lang.AssertionError: Internal error: While invoking metho= d 'public org.apache.calcite.sql2rel.RelFieldTrimmer$TrimResult org.apache.= calcite.sql2rel.RelFieldTrimmer.trimFields(org.apache.calcite.rel.core.Proj= ect,org.apache.calcite.util.ImmutableBitSet,java.util.Set)' > =09at org.apache.calcite.util.Util.newInternal(Util.java:743) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:543) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFi= eldTrimmer.java:269) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimme= r.java:210) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimm= er.java:345) > =09... 69 more > Caused by: java.lang.reflect.InvocationTargetException > =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImp= l.java:57) > =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc= essorImpl.java:43) > =09at java.lang.reflect.Method.invoke(Method.java:606) > =09at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:536) > =09... 72 more > Caused by: java.util.NoSuchElementException > =09at java.util.AbstractList$Itr.next(AbstractList.java:364) > =09at java.util.AbstractList.hashCode(AbstractList.java:540) > =09at org.apache.calcite.util.Util.hash(Util.java:230) > =09at org.apache.calcite.util.Pair.hashCode(Pair.java:87) > =09at com.google.common.base.Equivalences$Equals.doHash(Equivalences.java= :70) > =09at com.google.common.base.Equivalence.hash(Equivalence.java:105) > =09at com.google.common.cache.LocalCache.hash(LocalCache.java:1888) > =09at com.google.common.cache.LocalCache.getIfPresent(LocalCache.java:395= 3) > =09at com.google.common.cache.LocalCache$LocalManualCache.getIfPresent(Lo= calCache.java:4758) > =09at org.apache.calcite.rel.type.RelDataTypeFactoryImpl.canonize(RelData= TypeFactoryImpl.java:352) > =09at org.apache.calcite.rel.type.RelDataTypeFactoryImpl.createStructType= (RelDataTypeFactoryImpl.java:148) > =09at org.apache.calcite.rel.type.RelDataTypeFactoryImpl.createStructType= (RelDataTypeFactoryImpl.java:172) > =09at org.apache.calcite.plan.RelOptUtil.permute(RelOptUtil.java:2589) > =09at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimm= er.java:383) > =09... 77 more > {noformat} > query: > {noformat} > SELECT=C2=A0w_warehouse_name,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_warehouse_sq_ft,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_city,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_county,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_state,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_country,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ship_carriers,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0year,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Sum(jan_sales)=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0jan_sales,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Sum(feb_sales)=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0feb_sales,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Sum(jan_sales=C2=A0/=C2=A0w_war= ehouse_sq_ft)=C2=A0AS=C2=A0jan_sales_per_sq_foot,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Sum(feb_sales=C2=A0/=C2=A0w_war= ehouse_sq_ft)=C2=A0AS=C2=A0feb_sales_per_sq_foot,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Sum(jan_net)=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0jan_net,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Sum(feb_net)=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0feb_net=20 > FROM=C2=A0=C2=A0=C2=A0(SELECT=C2=A0w_warehouse_name,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_warehouse_sq_ft,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_city,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_county,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_state,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_country,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Concat('DHL',=C2=A0',',=C2=A0'BARIAN')=C2=A0AS=C2=A0ship_= carriers,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0d_year=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0AS=C2=A0year,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Sum(CASE=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHEN=C2=A0d_moy=C2=A0= =3D=C2=A01=C2=A0THEN=C2=A0ws_ext_sales_price=C2=A0*=C2=A0ws_quantity=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ELSE=C2=A0Cast(0=C2= =A0AS=C2=A0DECIMAL(7,=C2=A02))=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0end)=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0jan_sales,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Sum(CASE=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHEN=C2=A0d_moy=C2=A0= =3D=C2=A02=C2=A0THEN=C2=A0ws_ext_sales_price=C2=A0*=C2=A0ws_quantity=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ELSE=C2=A0Cast(0=C2= =A0AS=C2=A0DECIMAL(7,=C2=A02))=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0end)=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0feb_sales,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Sum(CASE=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHEN=C2=A0d_moy=C2=A0= =3D=C2=A01=C2=A0THEN=C2=A0ws_net_paid=C2=A0*=C2=A0ws_quantity=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ELSE=C2=A0Cast(0=C2= =A0AS=C2=A0DECIMAL(7,=C2=A02))=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0end)=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0jan_net,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Sum(CASE=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHEN=C2=A0d_moy=C2=A0= =3D=C2=A02=C2=A0THEN=C2=A0ws_net_paid=C2=A0*=C2=A0ws_quantity=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ELSE=C2=A0Cast(0=C2= =A0AS=C2=A0DECIMAL(7,=C2=A02))=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0end)=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0feb_net=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0FROM=C2=A0=C2=A0=C2=A0web= _sales=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0JOIN=C2=A0warehouse=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ON=C2=A0web_sales.ws_warehouse_sk=C2=A0=3D=C2= =A0warehouse.w_warehouse_sk=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0JOIN=C2=A0date_dim=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ON=C2=A0web_sales.ws_sold_date_sk=C2=A0=3D=C2= =A0date_dim.d_date_sk=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0JOIN=C2=A0time_dim=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ON=C2=A0web_sales.ws_sold_time_sk=C2=A0=3D=C2= =A0time_dim.t_time_sk=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0JOIN=C2=A0ship_mode=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ON=C2=A0web_sales.ws_ship_mode_sk=C2=A0=3D=C2= =A0ship_mode.sm_ship_mode_sk=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHERE=C2=A0=C2=A0d_year= =C2=A0=3D=C2=A02001=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0AND=C2=A0t_time=C2=A0BETWEEN=C2=A030838=C2=A0AND=C2=A0308= 38=C2=A0+=C2=A028800=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0AND=C2=A0sm_carrier=C2=A0IN=C2=A0(=C2=A0'DHL',=C2=A0'BARI= AN'=C2=A0)=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0GROUP=C2=A0=C2=A0BY=C2=A0= w_warehouse_name,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_warehouse_sq_ft,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_city,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_county,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_state,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_country,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0d_year=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0UNION DISTINCT > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0SELECT=C2=A0w_warehouse_n= ame,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_warehouse_sq_ft,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_city,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_county,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_state,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0w_country,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Concat('DHL',=C2=A0',',=C2=A0'BARIAN')=C2=A0AS=C2=A0ship_= carriers,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0d_year=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0AS=C2=A0year,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Sum(CASE=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHEN=C2=A0d_moy=C2=A0= =3D=C2=A01=C2=A0THEN=C2=A0cs_sales_price=C2=A0*=C2=A0cs_quantity=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ELSE=C2=A0Cast(0=C2= =A0AS=C2=A0DECIMAL(7,=C2=A02))=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0end)=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0jan_sales,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Sum(CASE=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHEN=C2=A0d_moy=C2=A0= =3D=C2=A02=C2=A0THEN=C2=A0cs_sales_price=C2=A0*=C2=A0cs_quantity=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ELSE=C2=A0Cast(0=C2= =A0AS=C2=A0DECIMAL(7,=C2=A02))=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0end)=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0feb_sales,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Sum(CASE=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHEN=C2=A0d_moy=C2=A0= =3D=C2=A01=C2=A0THEN=C2=A0cs_net_paid_inc_tax=C2=A0*=C2=A0cs_quantity=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ELSE=C2=A0Cast(0=C2= =A0AS=C2=A0DECIMAL(7,=C2=A02))=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0end)=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0jan_net,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0Sum(CASE=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHEN=C2=A0d_moy=C2=A0= =3D=C2=A02=C2=A0THEN=C2=A0cs_net_paid_inc_tax=C2=A0*=C2=A0cs_quantity=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ELSE=C2=A0Cast(0=C2= =A0AS=C2=A0DECIMAL(7,=C2=A02))=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0end)=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0AS=C2=A0feb_net=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0FROM=C2=A0=C2=A0=C2=A0cat= alog_sales=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0JOIN=C2=A0warehouse=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ON=C2=A0catalog_sales.cs_warehouse_sk=C2=A0= =3D=C2=A0warehouse.w_warehouse_sk=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0JOIN=C2=A0date_dim=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ON=C2=A0catalog_sales.cs_sold_date_sk=C2=A0= =3D=C2=A0date_dim.d_date_sk=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0JOIN=C2=A0time_dim=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ON=C2=A0catalog_sales.cs_sold_time_sk=C2=A0= =3D=C2=A0time_dim.t_time_sk=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0JOIN=C2=A0ship_mode=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ON=C2=A0catalog_sales.cs_ship_mode_sk=C2=A0= =3D=C2=A0ship_mode.sm_ship_mode_sk=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0WHERE=C2=A0=C2=A0d_year= =C2=A0=3D=C2=A02001=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0AND=C2=A0t_time=C2=A0BETWEEN=C2=A030838=C2=A0AND=C2=A0308= 38=C2=A0+=C2=A028800=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0AND=C2=A0sm_carrier=C2=A0IN=C2=A0(=C2=A0'DHL',=C2=A0'BARI= AN'=C2=A0)=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0GROUP=C2=A0=C2=A0BY=C2=A0= w_warehouse_name,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_warehouse_sq_ft,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_city,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_county,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_state,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_country,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0d_year)=C2=A0x=20 > GROUP=C2=A0=C2=A0BY=C2=A0w_warehouse_name,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_warehouse_s= q_ft,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_city,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_county,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_state,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0w_country,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ship_carriers= ,=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0year=20 > ORDER=C2=A0=C2=A0BY=C2=A0w_warehouse_name=20 > LIMIT=C2=A0=C2=A0100;=C2=A0 > {noformat} > Seems like use of Sum(jan_sales=C2=A0/=C2=A0w_warehouse_sq_ft)=C2=A0AS=C2= =A0jan_sales_per_sq_foot,=20 > Sum(feb_sales=C2=A0/=C2=A0w_warehouse_sq_ft)=C2=A0AS=C2=A0feb_sales_per_s= q_foot in the select clause causing the error. > Query works fine if I turn off cbo or remove these two columns from selec= t clause. -- This message was sent by Atlassian JIRA (v6.3.4#6332)