java.lang.RuntimeException: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'bungeeperms.bungeeperms_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT

GitHub | Rokirok | 4 months ago
  1. 0

    MySQL issue

    GitHub | 4 months ago | Rokirok
    java.lang.RuntimeException: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'bungeeperms.bungeeperms_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT
  2. 0

    Re: Cube Build Failed at Last Step//RE: Error while making cube & Measure option is not responding on GUI

    apache.org | 1 year ago
    java.lang.RuntimeException: Can't get cube segment >size. > at >com.kylinolap.job.flow.JobFlowListener.updateCubeSegmentInfoOnSucceed(JobF >lowListener.java:247) > at >com.kylinolap.job.flow.JobFlowListener.jobWasExecuted(JobFlowListener.java >:101) > at >org.quartz.core.QuartzScheduler.notifyJobListenersWasExecuted(QuartzSchedu >ler.java:1985) > at >org.quartz.core.JobRunShell.notifyJobListenersComplete(JobRunShell.java:34 >0) > at org.quartz.core.JobRunShell.run(JobRunShell.java:224) > at >org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:5 >73) > >I have checked in hbase shell and following are the tables in hbase; >hbase(main):001:0> list >TABLE > >KYLIN_K27LDMX63W >kylin_metadata_qa >kylin_metadata_qa_acl >kylin_metadata_qa_cube >kylin_metadata_qa_dict >kylin_metadata_qa_invertedindex >kylin_metadata_qa_job >kylin_metadata_qa_job_output >kylin_metadata_qa_proj >kylin_metadata_qa_table_snapshot >kylin_metadata_qa_user >11 row(s) in 0.8990 seconds > > >Regards, >Santosh Akhilesh >Bangalore R&D >HUAWEI TECHNOLOGIES CO.,LTD. > >www.huawei.com >-------------------------------------------------------------------------- >----------------------------------------------------------- >This e-mail and its attachments contain confidential information from >HUAWEI, which >is intended only for the person or entity whose address is listed above. >Any use of the >information contained herein in any way (including, but not limited to, >total or partial >disclosure, reproduction, or dissemination) by persons other than the >intended >recipient(s) is prohibited. If you receive this e-mail in error, please >notify the sender by >phone or email immediately and delete it! > >________________________________________ >From: Santoshakhilesh >Sent: Friday, February 27, 2015 2:15 PM >To: dev@kylin.incubator.apache.org >Subject: RE: Error while making cube & Measure option is not responding >on GUI > >I have manually copied the jar to /tmp/kylin , now satge 2 is done , >thanks. > >Regards, >Santosh Akhilesh >Bangalore R&D >HUAWEI TECHNOLOGIES CO.,LTD. > >www.huawei.com >-------------------------------------------------------------------------- >----------------------------------------------------------- >This e-mail and its attachments contain confidential information from >HUAWEI, which >is intended only for the person or entity whose address is listed above. >Any use of the >information contained herein in any way (including, but not limited to, >total or partial >disclosure, reproduction, or dissemination) by persons other than the >intended >recipient(s) is prohibited. If you receive this e-mail in error, please >notify the sender by >phone or email immediately and delete it! > >________________________________________ >From: Shi, Shaofeng [shaoshi@ebay.com] >Sent: Friday, February 27, 2015 1:00 PM >To: dev@kylin.incubator.apache.org >Cc: Kulbhushan Rana >Subject: Re: Error while making cube & Measure option is not responding >on GUI > >In 0.6.x the packages are named with “com.kylinolap.xxx”, from 0.7 we >renamed the package to “org.apache.kylin.xxx”; When you downgrade to 0.6, >did you also replace the jar location with 0.6 ones in kylin.properties? > >On 2/27/15, 3:13 PM, "Santoshakhilesh" >wrote: > Hi Shaofeng , I have added my fact and dimension tables under default database of hive. Now stage 1 of Cube Build is ok. And there is failure at step2. The map reduce job for the finding distinct columns of fact table is error. Yarn log is as below. Strangely this is class not found error. I have checked the Kylin.properties and the jar is already set as below. kylin. log has one exception connecting to linux/10.19.93.68 to 0.0.0.0:10020 Please help me to give a clue , I am also trying to check meanwhile Thanks. kylin property # Temp folder in hdfs kylin.hdfs.working.dir=/tmp # Path to the local(relative to job engine) job jar, job engine will use this jar kylin.job.jar=/tmp/kylin/kylin-job-latest.jar Map Reduce error ---------------------------- 2015-02-27 20:24:25,262 FATAL [main] org.apache.hadoop.mapred.YarnChild: Error running child : java.lang.NoClassDefFoundError: com/kylinolap/common/mr/KylinMapper
  3. 0

    Re: Cube Build Failed at Last Step//RE: Error while making cube & Measure option is not responding on GUI

    kylin-dev | 2 years ago | Santosh Akhilesh
    java.lang.RuntimeException: Can't get cube segment >>>size. >>> at >>>com.kylinolap.job.flow.JobFlowListener.updateCubeSegmentInfoOnSucceed(Jo >>>b >>>F >>>lowListener.java:247) >>> at >>>com.kylinolap.job.flow.JobFlowListener.jobWasExecuted(JobFlowListener.ja >>>v >>>a >>>:101) >>> at >>>org.quartz.core.QuartzScheduler.notifyJobListenersWasExecuted(QuartzSche >>>d >>>u >>>ler.java:1985) >>> at >>>org.quartz.core.JobRunShell.notifyJobListenersComplete(JobRunShell.java: >>>3 >>>4 >>>0) >>> at org.quartz.core.JobRunShell.run(JobRunShell.java:224) >>> at >>>org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java >>>: >>>5 >>>73) >>> >>>I have checked in hbase shell and following are the tables in hbase; >>>hbase(main):001:0> list >>>TABLE >>> >>>KYLIN_K27LDMX63W >>>kylin_metadata_qa >>>kylin_metadata_qa_acl >>>kylin_metadata_qa_cube >>>kylin_metadata_qa_dict >>>kylin_metadata_qa_invertedindex >>>kylin_metadata_qa_job >>>kylin_metadata_qa_job_output >>>kylin_metadata_qa_proj >>>kylin_metadata_qa_table_snapshot >>>kylin_metadata_qa_user >>>11 row(s) in 0.8990 seconds >>> >>> >>>Regards, >>>Santosh Akhilesh >>>Bangalore R&D >>>HUAWEI TECHNOLOGIES CO.,LTD. >>> >>>www.huawei.com >>>------------------------------------------------------------------------ >>>- >>>- >>>----------------------------------------------------------- >>>This e-mail and its attachments contain confidential information from >>>HUAWEI, which >>>is intended only for the person or entity whose address is listed above. >>>Any use of the >>>information contained herein in any way (including, but not limited to, >>>total or partial >>>disclosure, reproduction, or dissemination) by persons other than the >>>intended >>>recipient(s) is prohibited. If you receive this e-mail in error, please >>>notify the sender by >>>phone or email immediately and delete it! >>> >>>________________________________________ >>>From: Santoshakhilesh >>>Sent: Friday, February 27, 2015 2:15 PM >>>To: dev@kylin.incubator.apache.org >>>Subject: RE: Error while making cube & Measure option is not responding >>>on GUI >>> >>>I have manually copied the jar to /tmp/kylin , now satge 2 is done , >>>thanks. >>> >>>Regards, >>>Santosh Akhilesh >>>Bangalore R&D >>>HUAWEI TECHNOLOGIES CO.,LTD. >>> >>>www.huawei.com >>>------------------------------------------------------------------------ >>>- >>>- >>>----------------------------------------------------------- >>>This e-mail and its attachments contain confidential information from >>>HUAWEI, which >>>is intended only for the person or entity whose address is listed above. >>>Any use of the >>>information contained herein in any way (including, but not limited to, >>>total or partial >>>disclosure, reproduction, or dissemination) by persons other than the >>>intended >>>recipient(s) is prohibited. If you receive this e-mail in error, please >>>notify the sender by >>>phone or email immediately and delete it! >>> >>>________________________________________ >>>From: Shi, Shaofeng [shaoshi@ebay.com] >>>Sent: Friday, February 27, 2015 1:00 PM >>>To: dev@kylin.incubator.apache.org >>>Cc: Kulbhushan Rana >>>Subject: Re: Error while making cube & Measure option is not responding >>>on GUI >>> >>>In 0.6.x the packages are named with “com.kylinolap.xxx”, from 0.7 we >>>renamed the package to “org.apache.kylin.xxx”; When you downgrade to >>>0.6, >>>did you also replace the jar location with 0.6 ones in kylin.properties? >>> >>>On 2/27/15, 3:13 PM, "Santoshakhilesh" >>>wrote: >>> Hi Shaofeng , I have added my fact and dimension tables under default database of hive. Now stage 1 of Cube Build is ok. And there is failure at step2. The map reduce job for the finding distinct columns of fact table is error. Yarn log is as below. Strangely this is class not found error. I have checked the Kylin.properties and the jar is already set as below. kylin. log has one exception connecting to linux/10.19.93.68 to 0.0.0.0:10020 Please help me to give a clue , I am also trying to check meanwhile Thanks. kylin property # Temp folder in hdfs kylin.hdfs.working.dir=/tmp # Path to the local(relative to job engine) job jar, job engine will use this jar kylin.job.jar=/tmp/kylin/kylin-job-latest.jar Map Reduce error ---------------------------- 2015-02-27 20:24:25,262 FATAL [main] org.apache.hadoop.mapred.YarnChild: Error running child : java.lang.NoClassDefFoundError: com/kylinolap/common/mr/KylinMapper
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Query with outer join does not validate

    GitHub | 2 years ago | julie-sullivan
    java.lang.RuntimeException: Template query org.intermine.api.template.ApiTemplate{ name: Wild_Type_Exp_Short_Return, title: Wild-type Expression (with four result columns), comment: , description: Default query returns expression in wild-type backgrounds in standard or control environments. To search for expression of a specific gene, type the symbol (or part of the symbol plus wildcards, e.g. *fgf8*) in the "Gene > Symbol" box. To look for expression in groups of genes, make a list of the genes and use the checkbox to constrain the query to your custom list. To find expression in a particualr anatomical structure, enter it in the "ZFA Term > Name" box. To find subcellular expression, use the "Ontology Term > Name" box. , PathQuery( view: [Expression.gene.symbol, Expression.startStage.name, Expression.endStage.name, Expression.anatomy.name], orderBy: [Expression.gene.symbol ASC], constraints: {Expression.genotype.isWildType = true=B, Expression.expressionFound = true=C, Expression.gene.symbol = *=D, Expression.anatomy.name = *=E, Expression.environment.primaryIdentifier = ZDB-EXP-041102-1=G, Expression.environment.primaryIdentifier = ZDB-EXP-070511-5=A, Expression.subterm.name = *=F}, logic: B and C and D and E and (G or A) and F, outerJoinStatus: {Expression.subterm=OUTER}, descriptions: {}, description: Default query returns expression in wild-type backgrounds in standard or control environments. To search for expression of a specific gene, type the symbol (or part of the symbol plus wildcards, e.g. *fgf8*) in the "Gene > Symbol" box. To look for expression in groups of genes, make a list of the genes and use the checkbox to constrain the query to your custom list. To find expression in a particualr anatomical structure, enter it in the "ZFA Term > Name" box. To find subcellular expression, use the "Ontology Term > Name" box. )} does not validate: [Outer join status path Expression.subterm is not relevant to the query]
  6. 0

    [CASSANDRA-6631] cassandra-stress failing in trunk - ASF JIRA

    apache.org | 1 year ago
    java.lang.RuntimeException: java.lang.IllegalArgumentException: replicate_on_write is not a column defined in this metadata

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.RuntimeException

      java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'bungeeperms.bungeeperms_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT

      at net.alpenblock.bungeeperms.Mysql.returnQuery()
    2. net.alpenblock.bungeeperms
      MysqlPermsAdapter2.getGroups
      1. net.alpenblock.bungeeperms.Mysql.returnQuery(Mysql.java:232)
      2. net.alpenblock.bungeeperms.Mysql.returnQuery(Mysql.java:98)
      3. net.alpenblock.bungeeperms.io.mysql2.MysqlPermsAdapter2.getGroups(MysqlPermsAdapter2.java:44)
      3 frames