[jira] [Created] (KYLIN-2471) queries with parenthesized sub-clause in JOIN will fail

2017-02-25 Thread hongbin ma (JIRA) 
hongbin ma created KYLIN-2471:
-

 Summary: queries with parenthesized sub-clause in JOIN will fail
 Key: KYLIN-2471
 URL: https://issues.apache.org/jira/browse/KYLIN-2471
 Project: Kylin
  Issue Type: Bug
Reporter: hongbin ma
Assignee: hongbin ma


cognos will generate queries with parenthesized sub-clause in JOIN. for example:

{code}
SELECT "TABLE1"."DIM1_1" "DIM1_1"
   ,"TABLE2"."DIM2_1" "DIM2_1"
   ,SUM("FACT"."M1") "M1"
   ,SUM("FACT"."M2") "M2"
  FROM ("COGNOS"."FACT" "FACT" LEFT OUTER JOIN "COGNOS"."TABLE1"
"TABLE1" ON "FACT"."FK_1" = "TABLE1"."PK_1")
  LEFT OUTER JOIN "COGNOS"."TABLE2" "TABLE2"
ON "FACT"."FK_2" = "TABLE2"."PK_2"
 GROUP BY "TABLE2"."DIM2_1"
  ,"TABLE1"."DIM1_1";
{code}

as mentioned in https://issues.apache.org/jira/browse/CALCITE-35 such issue is 
difficult to handle in calcite. We'll leverage IQueryTransformer to remove 
unnecessary parentheses 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (KYLIN-2470) cube build failed it there is no hive data partitions from start time to end time

2017-02-25 Thread Billy Liu (JIRA) 

[ 
https://issues.apache.org/jira/browse/KYLIN-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15884150#comment-15884150
 ] 

Billy Liu commented on KYLIN-2470:
--

What's your expectation behavior?


> cube build failed it there is no hive data partitions from start time to end 
> time 
> --
>
> Key: KYLIN-2470
> URL: https://issues.apache.org/jira/browse/KYLIN-2470
> Project: Kylin
>  Issue Type: Wish
> Environment: hadoop2.7.3 hive2.1.1 hbase1.2.4 
> apache-kylin-1.6.0-hbase1.x-bin
>Reporter: zhou degao
>
> I hope the build will be successful then there is no hive data partitions.
> ERRORS are:
> java.lang.IllegalArgumentException: Map input splits are 0 bytes, something 
> is wrong!
>   at 
> org.apache.kylin.engine.mr.common.AbstractHadoopJob.getTotalMapInputMB(AbstractHadoopJob.java:555)
>   at 
> org.apache.kylin.engine.mr.steps.CuboidJob.setReduceTaskNum(CuboidJob.java:175)
>   at org.apache.kylin.engine.mr.steps.CuboidJob.run(CuboidJob.java:138)
>   at org.apache.kylin.engine.mr.MRUtil.runMRJob(MRUtil.java:92)
>   at 
> org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:120)
>   at 
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:113)
>   at 
> org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:57)
>   at 
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:113)
>   at 
> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:136)
>   at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>   at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>   at java.lang.Thread.run(Thread.java:745)
> result code:2
> In another environment 
> (hadoop2.6.4,hive1.2.1,hbase1.1.3,apache-kylin-1.6.0-hbase1.x-bin) the cube 
> build is successful if there is no hive data partitions from start time to 
> end time .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Resolved] (KYLIN-2102) use ·`bash` in script，not just sh

2017-02-25 Thread Billy Liu (JIRA) 

 [ 
https://issues.apache.org/jira/browse/KYLIN-2102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Billy Liu resolved KYLIN-2102.
--
Resolution: Fixed
  Assignee:  Kaige Liu  (was: Zhong,Jason)

Fixed at KYLIN-2362

> use ·`bash` in script，not just sh
> -
>
> Key: KYLIN-2102
> URL: https://issues.apache.org/jira/browse/KYLIN-2102
> Project: Kylin
>  Issue Type: Improvement
>  Components: General
>Affects Versions: all
>Reporter: chen
>Assignee:  Kaige Liu
>
> Sometimes the default shell is not bash.But the scripts ,for example 
> "get-properties.sh"、“kylin.sh”,use `sh xxx`.It may cause some strange mistack.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Created] (KYLIN-2470) cube build failed it there is no hive data partitions from start time to end time

2017-02-25 Thread zhou degao (JIRA) 
zhou degao created KYLIN-2470:
-

 Summary: cube build failed it there is no hive data partitions 
from start time to end time 
 Key: KYLIN-2470
 URL: https://issues.apache.org/jira/browse/KYLIN-2470
 Project: Kylin
  Issue Type: Wish
 Environment: hadoop2.7.3 hive2.1.1 hbase1.2.4 
apache-kylin-1.6.0-hbase1.x-bin
Reporter: zhou degao


I hope the build will be successful then there is no hive data partitions.
ERRORS are:
java.lang.IllegalArgumentException: Map input splits are 0 bytes, something is 
wrong!
at 
org.apache.kylin.engine.mr.common.AbstractHadoopJob.getTotalMapInputMB(AbstractHadoopJob.java:555)
at 
org.apache.kylin.engine.mr.steps.CuboidJob.setReduceTaskNum(CuboidJob.java:175)
at org.apache.kylin.engine.mr.steps.CuboidJob.run(CuboidJob.java:138)
at org.apache.kylin.engine.mr.MRUtil.runMRJob(MRUtil.java:92)
at 
org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:120)
at 
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:113)
at 
org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:57)
at 
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:113)
at 
org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:136)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

result code:2


In another environment 
(hadoop2.6.4,hive1.2.1,hbase1.1.3,apache-kylin-1.6.0-hbase1.x-bin) the cube 
build is successful if there is no hive data partitions from start time to end 
time .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)