You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/08/11 07:58:57 UTC

[GitHub] [doris] FelixDonChen opened a new issue, #11686: when use two view table left jon hive error not hive param

FelixDonChen opened a new issue, #11686:
URL: https://github.com/apache/doris/issues/11686

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   1.1.1
   
   ### What's Wrong?
   
        create view test.test_cdc_product_sku_correlation as 
                select 
                 sku_id, 
                 cor_alternative_id, 
                 cor_account_code, 
                 max(create_time) create_time
              from dim.dim_cdc_t_product_sku_correlation
              where cor_system = '1123'
              group by sku_id, cor_alternative_id, cor_account_code ;
   
    create view test.test_v_price_reptile as 
     SELECT
               t1.cor_alternative_id,
           CASE WHEN shelf_status = 1 THEN '上架' WHEN shelf_status = 2 THEN '无库存' ELSE '下架' END listing_Status
           FROM
               (SELECT 
                   cor_alternative_id,
                   max(etl_time) etl_time
               FROM dwd.dwd_esc_t_test_price_reptile
               where cor_alternative_id is not null
               GROUP BY 1)t1
               LEFT JOIN dwd.dwd_esc_t_test_price_reptile t2 
                 ON t1.cor_alternative_id = t2.cor_alternative_id AND t1.etl_time = t2.etl_time  ;
   
   select
    *
   from
    test.test_cdc_product_sku_correlation t1
   left join test.test_v_price_reptile t2 on
    t1.cor_alternative_id = t2.cor_alternative_id and t1.cor_alternative_id is not null;
   
   
   org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [1054] [42S22]: errCode = 2, detailMessage = Unknown column 'cor_alternative_id' in 't2'
   	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
   	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:577)
   	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:486)
   	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)
   	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:493)
   	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:894)
   	at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3642)
   	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)
   	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)
   	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)
   	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4891)
   	at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
   	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
   Caused by: java.sql.SQLSyntaxErrorException: errCode = 2, detailMessage = Unknown column 'cor_alternative_id' in 't2'
   	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
   	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
   	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
   	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
   	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:329)
   	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.lambda$0(JDBCStatementImpl.java:131)
   	at org.jkiss.dbeaver.utils.SecurityManagerUtils.wrapDriverActions(SecurityManagerUtils.java:94)
   	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)
   	... 12 more
   
   
   ### What You Expected?
   
   I use 0.15.3 and 1.1.0 no hive this issues!
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [doris] morrySnow commented on issue #11686: when use two view table left jon hive error not hive param

Posted by GitBox <gi...@apache.org>.
morrySnow commented on issue #11686:
URL: https://github.com/apache/doris/issues/11686#issuecomment-1211730490

   @FelixDonChen this bug will be fixed in version 1.1.2. It should be released at the end of this month or the beginning of next month


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [doris] kpfly commented on issue #11686: when use two view table left jon hive error not hive param

Posted by GitBox <gi...@apache.org>.
kpfly commented on issue #11686:
URL: https://github.com/apache/doris/issues/11686#issuecomment-1211733663

   > @FelixDonChen this bug will be fixed in version 1.1.2. It should be released at the end of this month or the beginning of next month
   
    version 1.1.2 will be released next week


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [doris] morrySnow commented on issue #11686: when use two view table left jon hive error not hive param

Posted by GitBox <gi...@apache.org>.
morrySnow commented on issue #11686:
URL: https://github.com/apache/doris/issues/11686#issuecomment-1211723672

   i think this could be resolved by #11566 , @englefly what do u think?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [doris] englefly commented on issue #11686: when use two view table left jon hive error not hive param

Posted by GitBox <gi...@apache.org>.
englefly commented on issue #11686:
URL: https://github.com/apache/doris/issues/11686#issuecomment-1211727635

   > cor_alternative_id
   
   yes, I think so.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] when use two view table left jon hive error not hive param [doris]

Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #11686: when use two view table left jon hive error not hive param
URL: https://github.com/apache/doris/issues/11686


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org