You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Exsword <st...@126.com> on 2015/06/29 11:18:47 UTC
Cube Build fails and if i drop the cube but the cube still on
the cube list
there is an issuse if i build any cube
error message :
,FACT_TABLE.PRICE
,FACT_TABLE.SELLER_ID
FROM DEFAULT.KYLIN_SALES as FACT_TABLE
INNER JOIN DEFAULT.KYLIN_CAL_DT as LOOKUP_1
ON FACT_TABLE.PART_DT = LOOKUP_1.CAL_DT
INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as LOOKUP_2
ON FACT_TABLE.LEAF_CATEG_ID = LOOKUP_2.LEAF_CATEG_ID AND FACT_TABLE.LSTG_SITE_ID = LOOKUP_2.SITE_ID
WHERE (FACT_TABLE.PART_DT < '2015-07-30')
;
"
line
line
line
line
line
line
at org.apache.kylin.common.util.CliCommandExecutor.execute(CliCommandExecutor.java:91)
at org.apache.kylin.job.common.ShellExecutable.doWork(ShellExecutable.java:52)
at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:50)
at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:132)
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)
can you tell me how can i build the cube sucessfully?
Re: Cube Build fails and if i drop the cube but the cube still on the
cube list
Posted by Diego Pinheiro <di...@gmail.com>.
If you try to do:
hive -e 'PASTE THE QUERY IN THE ERROR LOG' (as mentioned in the previous email)
and you get an error. Check your hive and map/reducer memory, try to
increase them.
On Mon, Jun 29, 2015 at 7:11 AM, 周千昊 <z....@gmail.com> wrote:
> it seems that your environment does not have the privilege to run hive
> query.
> To make sure, you can just exec
> hive -e 'PASTE THE QUERY IN THE ERROR LOG'
> to see if anything goes wrong
>
> hongbin ma <ma...@apache.org>于2015年6月29日周一 下午6:10写道：
>
>> can you paste more log here? seems we're losing some key messages
>>
>> On Mon, Jun 29, 2015 at 5:18 PM, Exsword <st...@126.com> wrote:
>>
>> > there is an issuse if i build any cube
>> > error message :
>> > ,FACT_TABLE.PRICE
>> > ,FACT_TABLE.SELLER_ID
>> > FROM DEFAULT.KYLIN_SALES as FACT_TABLE
>> > INNER JOIN DEFAULT.KYLIN_CAL_DT as LOOKUP_1
>> > ON FACT_TABLE.PART_DT = LOOKUP_1.CAL_DT
>> > INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as LOOKUP_2
>> > ON FACT_TABLE.LEAF_CATEG_ID = LOOKUP_2.LEAF_CATEG_ID AND
>> > FACT_TABLE.LSTG_SITE_ID = LOOKUP_2.SITE_ID
>> > WHERE (FACT_TABLE.PART_DT < '2015-07-30')
>> > ;
>> > "
>> > line
>> > line
>> > line
>> > line
>> > line
>> > line
>> >
>> >
>> > at
>> >
>> org.apache.kylin.common.util.CliCommandExecutor.execute(CliCommandExecutor.java:91)
>> > at
>> >
>> org.apache.kylin.job.common.ShellExecutable.doWork(ShellExecutable.java:52)
>> > at
>> >
>> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
>> > at
>> >
>> org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:50)
>> > at
>> >
>> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
>> > at
>> >
>> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:132)
>> > 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)
>> >
>> >
>> > can you tell me how can i build the cube sucessfully?
>> >
>> >
>>
>>
>> --
>> Regards,
>>
>> *Bin Mahone | 马洪宾*
>> Apache Kylin: http://kylin.io
>> Github: https://github.com/binmahone
>>
Re: Cube Build fails and if i drop the cube but the cube still on the
cube list
Posted by 周千昊 <z....@gmail.com>.
it seems that your environment does not have the privilege to run hive
query.
To make sure, you can just exec
hive -e 'PASTE THE QUERY IN THE ERROR LOG'
to see if anything goes wrong
hongbin ma <ma...@apache.org>于2015年6月29日周一 下午6:10写道：
> can you paste more log here? seems we're losing some key messages
>
> On Mon, Jun 29, 2015 at 5:18 PM, Exsword <st...@126.com> wrote:
>
> > there is an issuse if i build any cube
> > error message :
> > ,FACT_TABLE.PRICE
> > ,FACT_TABLE.SELLER_ID
> > FROM DEFAULT.KYLIN_SALES as FACT_TABLE
> > INNER JOIN DEFAULT.KYLIN_CAL_DT as LOOKUP_1
> > ON FACT_TABLE.PART_DT = LOOKUP_1.CAL_DT
> > INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as LOOKUP_2
> > ON FACT_TABLE.LEAF_CATEG_ID = LOOKUP_2.LEAF_CATEG_ID AND
> > FACT_TABLE.LSTG_SITE_ID = LOOKUP_2.SITE_ID
> > WHERE (FACT_TABLE.PART_DT < '2015-07-30')
> > ;
> > "
> > line
> > line
> > line
> > line
> > line
> > line
> >
> >
> > at
> >
> org.apache.kylin.common.util.CliCommandExecutor.execute(CliCommandExecutor.java:91)
> > at
> >
> org.apache.kylin.job.common.ShellExecutable.doWork(ShellExecutable.java:52)
> > at
> >
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
> > at
> >
> org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:50)
> > at
> >
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
> > at
> >
> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:132)
> > 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)
> >
> >
> > can you tell me how can i build the cube sucessfully?
> >
> >
>
>
> --
> Regards,
>
> *Bin Mahone | 马洪宾*
> Apache Kylin: http://kylin.io
> Github: https://github.com/binmahone
>
Re: Cube Build fails and if i drop the cube but the cube still on the
cube list
Posted by hongbin ma <ma...@apache.org>.
can you paste more log here? seems we're losing some key messages
On Mon, Jun 29, 2015 at 5:18 PM, Exsword <st...@126.com> wrote:
> there is an issuse if i build any cube
> error message :
> ,FACT_TABLE.PRICE
> ,FACT_TABLE.SELLER_ID
> FROM DEFAULT.KYLIN_SALES as FACT_TABLE
> INNER JOIN DEFAULT.KYLIN_CAL_DT as LOOKUP_1
> ON FACT_TABLE.PART_DT = LOOKUP_1.CAL_DT
> INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as LOOKUP_2
> ON FACT_TABLE.LEAF_CATEG_ID = LOOKUP_2.LEAF_CATEG_ID AND
> FACT_TABLE.LSTG_SITE_ID = LOOKUP_2.SITE_ID
> WHERE (FACT_TABLE.PART_DT < '2015-07-30')
> ;
> "
> line
> line
> line
> line
> line
> line
>
>
> at
> org.apache.kylin.common.util.CliCommandExecutor.execute(CliCommandExecutor.java:91)
> at
> org.apache.kylin.job.common.ShellExecutable.doWork(ShellExecutable.java:52)
> at
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
> at
> org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:50)
> at
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:107)
> at
> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:132)
> 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)
>
>
> can you tell me how can i build the cube sucessfully?
>
>
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone