You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Jaideep Dhok (JIRA)" <ji...@apache.org> on 2014/12/22 10:17:13 UTC

[jira] [Comment Edited] (LENS-34) dim-attribute query on cube

    [ https://issues.apache.org/jira/browse/LENS-34?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14255577#comment-14255577 ] 

Jaideep Dhok edited comment on LENS-34 at 12/22/14 9:16 AM:
------------------------------------------------------------

Join with another dimension without selecting any measure gives NPE.
Query -  select citytable.name from testCube where " + twoDaysRange;

Exception - 
{noformat}
java.lang.NullPointerException
	at org.apache.lens.cube.parse.AliasReplacer.doFieldValidation(AliasReplacer.java:118)
	at org.apache.lens.cube.parse.AliasReplacer.rewriteContext(AliasReplacer.java:71)
	at org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:186)
	at org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:170)
	at org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:181)
	at org.apache.lens.cube.parse.TestCubeRewriter.testDimAttributeQueryWithFact(TestCubeRewriter.java:1361)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:80)
	at org.testng.internal.Invoker.invokeMethod(Invoker.java:714)
	at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
	at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
	at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
	at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
	at org.testng.TestRunner.privateRun(TestRunner.java:767)
	at org.testng.TestRunner.run(TestRunner.java:617)
	at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
	at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
	at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
	at org.testng.SuiteRunner.run(SuiteRunner.java:240)
	at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
	at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
	at org.testng.TestNG.runSuitesSequentially(TestNG.java:1198)
	at org.testng.TestNG.runSuitesLocally(TestNG.java:1123)
	at org.testng.TestNG.run(TestNG.java:1031)
	at org.apache.maven.surefire.testng.TestNGExecutor.run(TestNGExecutor.java:69)
	at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.executeSingleClass(TestNGDirectoryTestSuite.java:120)
	at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.execute(TestNGDirectoryTestSuite.java:104)
	at org.apache.maven.surefire.testng.TestNGProvider.invoke(TestNGProvider.java:113)
	at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
{noformat}


was (Author: jaideepdhok):
Join with another dimension without selecting any measure gives NPE.
Query -  select citytable.name from testCube where " + twoDaysRange;

Exception - 
{noformat}
java.lang.NullPointerException
	at org.apache.lens.cube.parse.AliasReplacer.doFieldValidation(AliasReplacer.java:118)
	at org.apache.lens.cube.parse.AliasReplacer.rewriteContext(AliasReplacer.java:71)
	at org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:186)
	at org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:170)
	at org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:181)
	at org.apache.lens.cube.parse.TestCubeRewriter.testDimAttributeQueryWithFact(TestCubeRewriter.java:1361)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:80)
	at org.testng.internal.Invoker.invokeMethod(Invoker.java:714)
	at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
	at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
	at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
	at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
	at org.testng.TestRunner.privateRun(TestRunner.java:767)
	at org.testng.TestRunner.run(TestRunner.java:617)
	at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
	at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
	at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
	at org.testng.SuiteRunner.run(SuiteRunner.java:240)
	at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
	at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
	at org.testng.TestNG.runSuitesSequentially(TestNG.java:1198)
	at org.testng.TestNG.runSuitesLocally(TestNG.java:1123)
	at org.testng.TestNG.run(TestNG.java:1031)
	at org.apache.maven.surefire.testng.TestNGExecutor.run(TestNGExecutor.java:69)
	at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.executeSingleClass(TestNGDirectoryTestSuite.java:120)
	at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.execute(TestNGDirectoryTestSuite.java:104)
	at org.apache.maven.surefire.testng.TestNGProvider.invoke(TestNGProvider.java:113)
	at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 112.113 sec - in org.apache.lens.cube.parse.TestCubeRewriter
{noformat}

> dim-attribute query on cube
> ---------------------------
>
>                 Key: LENS-34
>                 URL: https://issues.apache.org/jira/browse/LENS-34
>             Project: Apache Lens
>          Issue Type: Task
>          Components: cube
>            Reporter: Amareshwari Sriramadasu
>            Assignee: Jaideep Dhok
>             Fix For: 2.0
>
>
> If only dim-attributes are queried from cube, cube query rewriter should pick  facts with least weight and even an aggregated fact if the dim-attribute is available in the aggregated fact.
> This issue to verify the above behavior by writing a unit test and fix the behavior if it is different from above.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)