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

ASF GitHub Bot commented on PHOENIX-6262:
-----------------------------------------

stoty commented on pull request #1072:
URL: https://github.com/apache/phoenix/pull/1072#issuecomment-755908560


   :broken_heart: **-1 overall**
   
   
   
   
   
   
   | Vote | Subsystem | Runtime | Comment |
   |:----:|----------:|--------:|:--------|
   | +0 :ok: |  reexec  |   1m 52s |  Docker mode activated.  |
   ||| _ Prechecks _ |
   | +1 :green_heart: |  dupname  |   0m  0s |  No case conflicting files 
found.  |
   | +1 :green_heart: |  hbaseanti  |   0m  0s |  Patch does not have any 
anti-patterns.  |
   | +1 :green_heart: |  @author  |   0m  0s |  The patch does not contain any 
@author tags.  |
   | +1 :green_heart: |  test4tests  |   0m  0s |  The patch appears to include 
3 new or modified test files.  |
   ||| _ master Compile Tests _ |
   | +1 :green_heart: |  mvninstall  |  16m 53s |  master passed  |
   | +1 :green_heart: |  compile  |   1m  1s |  master passed  |
   | +1 :green_heart: |  checkstyle  |   0m 44s |  master passed  |
   | +1 :green_heart: |  javadoc  |   0m 50s |  master passed  |
   | +0 :ok: |  spotbugs  |   3m 20s |  phoenix-core in master has 972 extant 
spotbugs warnings.  |
   ||| _ Patch Compile Tests _ |
   | +1 :green_heart: |  mvninstall  |   9m 23s |  the patch passed  |
   | +1 :green_heart: |  compile  |   1m  0s |  the patch passed  |
   | +1 :green_heart: |  javac  |   1m  0s |  the patch passed  |
   | -1 :x: |  checkstyle  |   0m 46s |  phoenix-core: The patch generated 67 
new + 1087 unchanged - 167 fixed = 1154 total (was 1254)  |
   | +1 :green_heart: |  whitespace  |   0m  0s |  The patch has no whitespace 
issues.  |
   | -1 :x: |  javadoc  |   0m 47s |  phoenix-core generated 1 new + 99 
unchanged - 1 fixed = 100 total (was 100)  |
   | -1 :x: |  spotbugs  |   3m 31s |  phoenix-core generated 2 new + 972 
unchanged - 0 fixed = 974 total (was 972)  |
   ||| _ Other Tests _ |
   | -1 :x: |  unit  | 175m 13s |  phoenix-core in the patch failed.  |
   | -1 :x: |  asflicense  |   0m 27s |  The patch generated 1 ASF License 
warnings.  |
   |  |   | 218m 33s |   |
   
   
   | Reason | Tests |
   |-------:|:------|
   | FindBugs | module:phoenix-core |
   |  |  Null passed for non-null parameter of 
org.apache.phoenix.util.PhoenixRuntime.getTable(Connection, String) in 
org.apache.phoenix.mapreduce.AbstractBulkLoadTool.loadData(Configuration, 
CommandLine)  Method invoked at AbstractBulkLoadTool.java:of 
org.apache.phoenix.util.PhoenixRuntime.getTable(Connection, String) in 
org.apache.phoenix.mapreduce.AbstractBulkLoadTool.loadData(Configuration, 
CommandLine)  Method invoked at AbstractBulkLoadTool.java:[line 284] |
   |  |  Null passed for non-null parameter of new 
org.apache.phoenix.schema.PTableKey(PName, String) in 
org.apache.phoenix.util.PhoenixRuntime.getTable(Connection, String)  Method 
invoked at PhoenixRuntime.java:of new 
org.apache.phoenix.schema.PTableKey(PName, String) in 
org.apache.phoenix.util.PhoenixRuntime.getTable(Connection, String)  Method 
invoked at PhoenixRuntime.java:[line 458] |
   | Failed junit tests | phoenix.end2end.TenantSpecificTablesDDLIT |
   |   | phoenix.end2end.join.HashJoinPersistentCacheIT |
   
   
   | Subsystem | Report/Notes |
   |----------:|:-------------|
   | Docker | ClientAPI=1.41 ServerAPI=1.41 base: 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1072/1/artifact/yetus-general-check/output/Dockerfile
 |
   | GITHUB PR | https://github.com/apache/phoenix/pull/1072 |
   | Optional Tests | dupname asflicense javac javadoc unit spotbugs hbaseanti 
checkstyle compile |
   | uname | Linux 8425568a8100 4.15.0-126-generic #129-Ubuntu SMP Mon Nov 23 
18:53:38 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux |
   | Build tool | maven |
   | Personality | dev/phoenix-personality.sh |
   | git revision | master / 5ef5faa |
   | Default Java | Private Build-1.8.0_242-8u242-b08-0ubuntu3~16.04-b08 |
   | checkstyle | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1072/1/artifact/yetus-general-check/output/diff-checkstyle-phoenix-core.txt
 |
   | javadoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1072/1/artifact/yetus-general-check/output/diff-javadoc-javadoc-phoenix-core.txt
 |
   | spotbugs | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1072/1/artifact/yetus-general-check/output/new-spotbugs-phoenix-core.html
 |
   | unit | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1072/1/artifact/yetus-general-check/output/patch-unit-phoenix-core.txt
 |
   |  Test Results | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1072/1/testReport/
 |
   | asflicense | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1072/1/artifact/yetus-general-check/output/patch-asflicense-problems.txt
 |
   | Max. process+thread count | 5860 (vs. ulimit of 30000) |
   | modules | C: phoenix-core U: phoenix-core |
   | Console output | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1072/1/console
 |
   | versions | git=2.7.4 maven=3.3.9 spotbugs=4.1.3 |
   | Powered by | Apache Yetus 0.12.0 https://yetus.apache.org |
   
   
   This message was automatically generated.
   
   


----------------------------------------------------------------
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.

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


> Bulk Load have a bug in lowercase tablename
> -------------------------------------------
>
>                 Key: PHOENIX-6262
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6262
>             Project: Phoenix
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 5.0.0
>            Reporter: zhengjiewen
>            Assignee: Chao Wang
>            Priority: Major
>             Fix For: 5.1.0
>
>         Attachments: PHOENIX-6262.master.001.patch, 
> PHOENIX-6262.master.002.patch, PHOENIX-6262.master.003.patch
>
>
> h1. Bulk Load in lowercase tablename
> {color:#172b4d}when I use phoenix bulk load command to import csv file to 
> phoenix table,{color} there{color:#172b4d} are get error.{color}
> {code:java}
> //代码占位符
> Exception in thread "main" java.lang.IllegalArgumentException: Table 
> "test"."ods_om_om_order_test" not foundException in thread "main" 
> java.lang.IllegalArgumentException: Table "test"."ods_om_om_order_test" not 
> found at 
> org.apache.phoenix.util.SchemaUtil.generateColumnInfo(SchemaUtil.java:956) at 
> org.apache.phoenix.mapreduce.AbstractBulkLoadTool.buildImportColumns(AbstractBulkLoadTool.java:377)
>  at 
> org.apache.phoenix.mapreduce.AbstractBulkLoadTool.loadData(AbstractBulkLoadTool.java:211)
>  at 
> org.apache.phoenix.mapreduce.AbstractBulkLoadTool.run(AbstractBulkLoadTool.java:180)
>  at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at 
> org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90) at 
> org.apache.phoenix.mapreduce.CsvBulkLoadTool.main(CsvBulkLoadTool.java:109) 
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  at java.lang.reflect.Method.invoke(Method.java:498) at 
> org.apache.hadoop.util.RunJar.run(RunJar.java:313) at 
> org.apache.hadoop.util.RunJar.main(RunJar.java:227)
> {code}
> my command is :
> {code:java}
> hadoop jar 
> /opt/cloudera/parcels/CDH/lib/hbase/lib/phoenix-5.0.0-cdh6.2.0-client.jar 
> org.apache.phoenix.mapreduce.CsvBulkLoadTool -s \"\"test\"\" -t 
> \"\"ods_om_om_order_test\"\" -i 
> /tmp/phoenix/ods_om_om_order_test5/data.csv{code}
> {color:#172b4d}And I found the source code have a bug in 
> *org.apache.phoenix.jdbc.PhoenixDatabaseMetaData#*{color}*getColumns.*
> This method splices the tableName and schemaName into SQL statements to query 
> the System.catalog. but if your tableName or schemaName is lowercase,that 
> would be the *'"test"'* and *'"ods_om_om_order_test"'* so that will can not 
> query the result and then return table not found exception.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to