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 <[email protected]>于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 <[email protected]> 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
>

Reply via email to