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

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

stoty commented on PR #139:
URL: 
https://github.com/apache/phoenix-connectors/pull/139#issuecomment-2295288151

   :broken_heart: **-1 overall**
   
   
   
   
   
   
   | Vote | Subsystem | Runtime | Comment |
   |:----:|----------:|--------:|:--------|
   | +0 :ok: |  reexec  |   6m 32s |  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 :x: |  test4tests  |   0m  0s |  The patch doesn't appear to include 
any new or modified tests. Please justify why no new tests are needed for this 
patch. Also please list what manual steps were performed to verify this patch.  
|
   ||| _ master Compile Tests _ |
   | +0 :ok: |  mvndep  |  10m 58s |  Maven dependency ordering for branch  |
   | -1 :x: |  mvninstall  |   0m  9s |  root in master failed.  |
   | -1 :x: |  compile  |   0m  8s |  phoenix5-spark in master failed.  |
   | -1 :x: |  compile  |   0m  9s |  phoenix5-spark3 in master failed.  |
   | +1 :green_heart: |  checkstyle  |   0m 33s |  master passed  |
   | -1 :x: |  javadoc  |   0m  9s |  phoenix5-spark in master failed.  |
   | -1 :x: |  javadoc  |   0m  9s |  phoenix5-spark3 in master failed.  |
   | -1 :x: |  scaladoc  |   0m  8s |  phoenix5-spark in master failed.  |
   | -1 :x: |  scaladoc  |   0m  9s |  phoenix5-spark3 in master failed.  |
   | -1 :x: |  spotbugs  |   0m  8s |  phoenix5-spark in master failed.  |
   | -1 :x: |  spotbugs  |   0m  9s |  phoenix5-spark3 in master failed.  |
   ||| _ Patch Compile Tests _ |
   | +0 :ok: |  mvndep  |   0m  9s |  Maven dependency ordering for patch  |
   | -1 :x: |  mvninstall  |   0m  6s |  root in the patch failed.  |
   | -1 :x: |  compile  |   0m  9s |  phoenix5-spark in the patch failed.  |
   | -1 :x: |  compile  |   0m  8s |  phoenix5-spark3 in the patch failed.  |
   | -1 :x: |  javac  |   0m  9s |  phoenix5-spark in the patch failed.  |
   | -1 :x: |  javac  |   0m  8s |  phoenix5-spark3 in the patch failed.  |
   | -1 :x: |  scalac  |   0m  9s |  phoenix5-spark in the patch failed.  |
   | -1 :x: |  scalac  |   0m  8s |  phoenix5-spark3 in the patch failed.  |
   | -1 :x: |  checkstyle  |   0m  8s |  phoenix5-spark: The patch generated 15 
new + 22 unchanged - 73 fixed = 37 total (was 95)  |
   | -1 :x: |  checkstyle  |   0m 10s |  phoenix5-spark3: The patch generated 
19 new + 38 unchanged - 81 fixed = 57 total (was 119)  |
   | -1 :x: |  whitespace  |   0m  0s |  The patch has 1 line(s) that end in 
whitespace. Use git apply --whitespace=fix <<patch_file>>. Refer 
https://git-scm.com/docs/git-apply  |
   | -1 :x: |  javadoc  |   0m  8s |  phoenix5-spark in the patch failed.  |
   | -1 :x: |  javadoc  |   0m  9s |  phoenix5-spark3 in the patch failed.  |
   | -1 :x: |  scaladoc  |   0m  9s |  phoenix5-spark in the patch failed.  |
   | -1 :x: |  scaladoc  |   0m  9s |  phoenix5-spark3 in the patch failed.  |
   | -1 :x: |  spotbugs  |   0m  9s |  phoenix5-spark in the patch failed.  |
   | -1 :x: |  spotbugs  |   0m  8s |  phoenix5-spark3 in the patch failed.  |
   ||| _ Other Tests _ |
   | -1 :x: |  unit  |   0m  9s |  phoenix5-spark in the patch failed.  |
   | -1 :x: |  unit  |   0m  8s |  phoenix5-spark3 in the patch failed.  |
   | -1 :x: |  asflicense  |   0m 17s |  The patch generated 4 ASF License 
warnings.  |
   |  |   |  22m  8s |   |
   
   
   | Subsystem | Report/Notes |
   |----------:|:-------------|
   | Docker | ClientAPI=1.46 ServerAPI=1.46 base: 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/Dockerfile
 |
   | GITHUB PR | https://github.com/apache/phoenix-connectors/pull/139 |
   | Optional Tests | dupname asflicense javac javadoc unit spotbugs hbaseanti 
checkstyle compile scalac scaladoc |
   | uname | Linux 1dbaf2f28949 5.15.0-118-generic #128-Ubuntu SMP Fri Jul 5 
09:28:59 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux |
   | Build tool | maven |
   | Personality | dev/phoenix-connectors-personality.sh |
   | git revision | master / a1c298c |
   | Default Java | Private Build-1.8.0_242-8u242-b08-0ubuntu3~16.04-b08 |
   | mvninstall | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-mvninstall-root.txt
 |
   | compile | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-compile-phoenix5-spark.txt
 |
   | compile | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-compile-phoenix5-spark3.txt
 |
   | javadoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-javadoc-phoenix5-spark.txt
 |
   | javadoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-javadoc-phoenix5-spark3.txt
 |
   | scaladoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-scaladoc-phoenix5-spark.txt
 |
   | scaladoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-scaladoc-phoenix5-spark3.txt
 |
   | spotbugs | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-spotbugs-phoenix5-spark.txt
 |
   | spotbugs | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/branch-spotbugs-phoenix5-spark3.txt
 |
   | mvninstall | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-mvninstall-root.txt
 |
   | compile | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-compile-phoenix5-spark.txt
 |
   | compile | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-compile-phoenix5-spark3.txt
 |
   | javac | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-compile-phoenix5-spark.txt
 |
   | javac | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-compile-phoenix5-spark3.txt
 |
   | scalac | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-compile-phoenix5-spark.txt
 |
   | scalac | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-compile-phoenix5-spark3.txt
 |
   | checkstyle | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/diff-checkstyle-phoenix5-spark.txt
 |
   | checkstyle | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/diff-checkstyle-phoenix5-spark3.txt
 |
   | whitespace | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/whitespace-eol.txt
 |
   | javadoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-javadoc-phoenix5-spark.txt
 |
   | javadoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-javadoc-phoenix5-spark3.txt
 |
   | scaladoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-scaladoc-phoenix5-spark.txt
 |
   | scaladoc | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-scaladoc-phoenix5-spark3.txt
 |
   | spotbugs | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-spotbugs-phoenix5-spark.txt
 |
   | spotbugs | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-spotbugs-phoenix5-spark3.txt
 |
   | unit | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-unit-phoenix5-spark.txt
 |
   | unit | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-unit-phoenix5-spark3.txt
 |
   |  Test Results | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/testReport/
 |
   | asflicense | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/artifact/yetus-general-check/output/patch-asflicense-problems.txt
 |
   | Max. process+thread count | 47 (vs. ulimit of 30000) |
   | modules | C: phoenix5-spark phoenix5-spark3 U: . |
   | Console output | 
https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-Connectors-PreCommit-GitHub-PR/job/PR-139/1/console
 |
   | versions | git=2.7.4 maven=3.3.9 |
   | Powered by | Apache Yetus 0.12.0 https://yetus.apache.org |
   
   
   This message was automatically generated.
   
   




> Phoenix5-Spark3 Connector Spark SQL Support
> -------------------------------------------
>
>                 Key: PHOENIX-6783
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6783
>             Project: Phoenix
>          Issue Type: Bug
>          Components: connectors, spark-connector
>         Environment: # Pure Spark 3.0.3
>  # phoenix5-spark3-shaded-6.0.0-SNAPSHOT.jar located in $SPARK_HOME/jars
>  # SQL used to create Spark Phoenix data source table is:
> {{create table Table1 (ID long, COL1 string) using  phoenix options (table 
> 'Table1', zkUrl '192.168.0.103:2181', primary 'ID')}}
>            Reporter: yj
>            Assignee: rejeb ben rejeb
>            Priority: Major
>
> While conducting the Spark 3.0 Integration test using *Phoenix5-spark3-shaded 
> module of project 
> [Phoenix-Connectors|https://github.com/apache/phoenix-connectors]* the 
> following questions occurred.
>  
> The test process is as follows:
> 1. Phoenix created a table called "TABLE1" and then loaded the data into that 
> table.
> 2. After that, I tried to select the data of the table using Spark.
>  
> As written in the README of Phoenix5-spark3 module, the part that loads 
> Phoenix data into the Spark DataFrame using the Phoenix data source seems to 
> work well.
> However, when I *create Phoenix Spark data source table through Spark SQL* 
> and try to select that data source table, the following error occurs:
> {{java.util.concurrent.ExecutionException: 
> org.apache.spark.sql.AnalysisException: phoenix is not a valid Spark SQL Data 
> Source}}
>  
> I wonder if the Phoenix-Connectors does not support creating Phoenix Spark 
> data source tables, or if there is any other reason for this error.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to