[ 
https://issues.apache.org/jira/browse/KYLIN-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16585501#comment-16585501
 ] 

ASF GitHub Bot commented on KYLIN-3500:
---------------------------------------

codecov-io commented on issue #203: KYLIN-3500 fix duplicated tablename at 
createSqoopToFlatHiveStep  wh…
URL: https://github.com/apache/kylin/pull/203#issuecomment-414216240
 
 
   # [Codecov](https://codecov.io/gh/apache/kylin/pull/203?src=pr&el=h1) Report
   > Merging [#203](https://codecov.io/gh/apache/kylin/pull/203?src=pr&el=desc) 
into 
[master](https://codecov.io/gh/apache/kylin/commit/b4f21550a773965eb93c639d1c5437661cb5b36f?src=pr&el=desc)
 will **increase** coverage by `<.01%`.
   > The diff coverage is `0%`.
   
   [![Impacted file tree 
graph](https://codecov.io/gh/apache/kylin/pull/203/graphs/tree.svg?token=JawVgbgsVo&src=pr&height=150&width=650)](https://codecov.io/gh/apache/kylin/pull/203?src=pr&el=tree)
   
   ```diff
   @@             Coverage Diff              @@
   ##             master     #203      +/-   ##
   ============================================
   + Coverage     21.01%   21.02%   +<.01%     
   - Complexity     4296     4297       +1     
   ============================================
     Files          1071     1071              
     Lines         68175    68173       -2     
     Branches       9893     9893              
   ============================================
   + Hits          14330    14331       +1     
   + Misses        52476    52473       -3     
     Partials       1369     1369
   ```
   
   
   | [Impacted 
Files](https://codecov.io/gh/apache/kylin/pull/203?src=pr&el=tree) | Coverage Δ 
| Complexity Δ | |
   |---|---|---|---|
   | 
[.../org/apache/kylin/source/jdbc/JdbcHiveMRInput.java](https://codecov.io/gh/apache/kylin/pull/203/diff?src=pr&el=tree#diff-c291cmNlLWhpdmUvc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL3NvdXJjZS9qZGJjL0pkYmNIaXZlTVJJbnB1dC5qYXZh)
 | `0% <0%> (ø)` | `0 <0> (ø)` | :arrow_down: |
   | 
[.../apache/kylin/cube/cuboid/TreeCuboidScheduler.java](https://codecov.io/gh/apache/kylin/pull/203/diff?src=pr&el=tree#diff-Y29yZS1jdWJlL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9jdWJlL2N1Ym9pZC9UcmVlQ3Vib2lkU2NoZWR1bGVyLmphdmE=)
 | `63.84% <0%> (-2.31%)` | `0% <0%> (ø)` | |
   | 
[...lin/dict/lookup/cache/RocksDBLookupTableCache.java](https://codecov.io/gh/apache/kylin/pull/203/diff?src=pr&el=tree#diff-Y29yZS1kaWN0aW9uYXJ5L3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9kaWN0L2xvb2t1cC9jYWNoZS9Sb2Nrc0RCTG9va3VwVGFibGVDYWNoZS5qYXZh)
 | `76.16% <0%> (-0.52%)` | `27% <0%> (ø)` | |
   | 
[...rg/apache/kylin/cube/inmemcubing/MemDiskStore.java](https://codecov.io/gh/apache/kylin/pull/203/diff?src=pr&el=tree#diff-Y29yZS1jdWJlL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9jdWJlL2lubWVtY3ViaW5nL01lbURpc2tTdG9yZS5qYXZh)
 | `70.21% <0%> (+0.91%)` | `7% <0%> (ø)` | :arrow_down: |
   | 
[...he/kylin/dict/lookup/cache/RocksDBLookupTable.java](https://codecov.io/gh/apache/kylin/pull/203/diff?src=pr&el=tree#diff-Y29yZS1kaWN0aW9uYXJ5L3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9kaWN0L2xvb2t1cC9jYWNoZS9Sb2Nrc0RCTG9va3VwVGFibGUuamF2YQ==)
 | `78.37% <0%> (+5.4%)` | `6% <0%> (+1%)` | :arrow_up: |
   
   ------
   
   [Continue to review full report at 
Codecov](https://codecov.io/gh/apache/kylin/pull/203?src=pr&el=continue).
   > **Legend** - [Click here to learn 
more](https://docs.codecov.io/docs/codecov-delta)
   > `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data`
   > Powered by 
[Codecov](https://codecov.io/gh/apache/kylin/pull/203?src=pr&el=footer). Last 
update 
[b4f2155...64114d1](https://codecov.io/gh/apache/kylin/pull/203?src=pr&el=lastupdated).
 Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


> kylin 2.4 use jdbc datasource :Unknown column 'A.A.CRT_DATE' in 'where clause'
> ------------------------------------------------------------------------------
>
>                 Key: KYLIN-3500
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3500
>             Project: Kylin
>          Issue Type: Bug
>          Components: RDBMS Source
>    Affects Versions: v2.3.0, v2.4.0
>         Environment: Hadoop2.7.6+Hive-1.2.2+HBase1.2.6+Sqoop1.4.7
>            Reporter: cqli
>            Assignee: Shaoxiong Zhan
>            Priority: Major
>             Fix For: v2.4.1, v2.5.0
>
>         Attachments: TIM图片20180815175301.png, TIM图片20180815175342.png, 
> TIM图片20180815175407.png
>
>
> Kylin2.4 
> 使用JDBC数据源,构建时通过Sqoop从mysql抽取数据到hive报错,split-by字段出现名重复:tablename.tablename.field
> sqoop-1.4.6/bin/sqoop import 
> -Dorg.apache.sqoop.splitter.allow_text_splitter=true 
> -Dmapreduce.job.queuename=default --connect 
> "jdbc:mysql://192.168.31.108:3306/kylin_jdbcresource_test" --driver 
> com.mysql.jdbc.Driver --username root --password root1324 --query "SELECT 
> A.NAME as A_NAME ,A.CRT_DATE FROM KYLIN_JDBCRESOURCE_TEST.A as A  WHERE 1=1 
> AND (A.CRT_DATE >= '2018-08-01 00:00:00' AND A.CRT_DATE < '2018-08-16 
> 00:00:00')  AND \$CONDITIONS" --target-dir 
> hdfs://localhost:9000/kylin/kylin_metadata/kylin-6bbe475b-ad11-4501-b3db-a56ee0222c90/kylin_intermediate_jdbc_resource_cube_7a4bd639_38ac_41be_9fba_6c64e040b175{color:#ff0000}
>  --split-by A.A.CRT_DATE{color} --boundary-query "SELECT min(A.CRT_DATE), 
> max(A.CRT_DATE) FROM "KYLIN_JDBCRESOURCE_TEST".A as A WHERE A.CRT_DATE >= 
> '2018-08-01 00:00:00' AND A.CRT_DATE < '2018-08-16 00:00:00'" --null-string 
> '' --fields-terminated-by '|' --num-mappers 1
> Caused by: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:{color:#ff0000} 
> Unknown column 'A.A.CRT_DATE' in 'where clause'{color}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to