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, 周千昊 <[email protected]> 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 <[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 >>
