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

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

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

   My local runs also fail:
   
    - Can use extraOptions to set configs for workers during writes *** FAILED 
*** (14 milliseconds)
     20 did not equal 0 (PhoenixSparkIT.scala:407)
     org.scalatest.exceptions.TestFailedException:
     at 
org.scalatest.MatchersHelper$.newTestFailedException(MatchersHelper.scala:160)
     at org.scalatest.Matchers$AnyShouldWrapper.shouldEqual(Matchers.scala:6303)
     at 
org.apache.phoenix.spark.PhoenixSparkIT$$anonfun$17.apply$mcV$sp(PhoenixSparkIT.scala:407)
     at 
org.apache.phoenix.spark.PhoenixSparkIT$$anonfun$17.apply(PhoenixSparkIT.scala:378)
     at 
org.apache.phoenix.spark.PhoenixSparkIT$$anonfun$17.apply(PhoenixSparkIT.scala:378)
     at 
org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
     at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
     at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
     at org.scalatest.Transformer.apply(Transformer.scala:22)
     at org.scalatest.Transformer.apply(Transformer.scala:20)
     at org.scalatest.FunSuiteLike$$anon$1.apply(FunSuiteLike.scala:166)
     at org.scalatest.Suite$class.withFixture(Suite.scala:1122)
     at org.scalatest.FunSuite.withFixture(FunSuite.scala:1555)
     at 
org.scalatest.FunSuiteLike$class.invokeWithFixture$1(FunSuiteLike.scala:163)
     at 
org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:175)
     at 
org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:175)
     at org.scalatest.SuperEngine.runTestImpl(Engine.scala:306)
     at org.scalatest.FunSuiteLike$class.runTest(FunSuiteLike.scala:175)
     at 
org.apache.phoenix.spark.AbstractPhoenixSparkIT.org$scalatest$BeforeAndAfter$$super$runTest(AbstractPhoenixSparkIT.scala:53)
     at org.scalatest.BeforeAndAfter$class.runTest(BeforeAndAfter.scala:200)
     at 
org.apache.phoenix.spark.AbstractPhoenixSparkIT.runTest(AbstractPhoenixSparkIT.scala:53)
     at 
org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:208)
     at 
org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:208)
     at 
org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:413)
     at 
org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:401)
     at scala.collection.immutable.List.foreach(List.scala:392)
     at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:401)
     at 
org.scalatest.SuperEngine.org$scalatest$SuperEngine$$runTestsInBranch(Engine.scala:396)
     at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:483)
     at org.scalatest.FunSuiteLike$class.runTests(FunSuiteLike.scala:208)
     at org.scalatest.FunSuite.runTests(FunSuite.scala:1555)
     at org.scalatest.Suite$class.run(Suite.scala:1424)
     at 
org.scalatest.FunSuite.org$scalatest$FunSuiteLike$$super$run(FunSuite.scala:1555)
     at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:212)
     at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:212)
     at org.scalatest.SuperEngine.runImpl(Engine.scala:545)
     at org.scalatest.FunSuiteLike$class.run(FunSuiteLike.scala:212)
     at 
org.apache.phoenix.spark.AbstractPhoenixSparkIT.org$scalatest$BeforeAndAfter$$super$run(AbstractPhoenixSparkIT.scala:53)
     at org.scalatest.BeforeAndAfter$class.run(BeforeAndAfter.scala:241)
     at 
org.apache.phoenix.spark.AbstractPhoenixSparkIT.org$scalatest$BeforeAndAfterAll$$super$run(AbstractPhoenixSparkIT.scala:53)
     at 
org.scalatest.BeforeAndAfterAll$class.liftedTree1$1(BeforeAndAfterAll.scala:257)
     at org.scalatest.BeforeAndAfterAll$class.run(BeforeAndAfterAll.scala:256)
     at 
org.apache.phoenix.spark.AbstractPhoenixSparkIT.run(AbstractPhoenixSparkIT.scala:53)
     at org.scalatest.Suite$class.callExecuteOnSuite$1(Suite.scala:1492)
     at org.scalatest.Suite$$anonfun$runNestedSuites$1.apply(Suite.scala:1528)
     at org.scalatest.Suite$$anonfun$runNestedSuites$1.apply(Suite.scala:1526)
     at 
scala.collection.IndexedSeqOptimized$class.foreach(IndexedSeqOptimized.scala:33)
     at scala.collection.mutable.ArrayOps$ofRef.foreach(ArrayOps.scala:186)
     at org.scalatest.Suite$class.runNestedSuites(Suite.scala:1526)
     at 
org.scalatest.tools.DiscoverySuite.runNestedSuites(DiscoverySuite.scala:29)
     at org.scalatest.Suite$class.run(Suite.scala:1421)
     at org.scalatest.tools.DiscoverySuite.run(DiscoverySuite.scala:29)
     at org.scalatest.tools.SuiteRunner.run(SuiteRunner.scala:55)
     at 
org.scalatest.tools.Runner$$anonfun$doRunRunRunDaDoRunRun$3.apply(Runner.scala:2563)
     at 
org.scalatest.tools.Runner$$anonfun$doRunRunRunDaDoRunRun$3.apply(Runner.scala:2557)
     at scala.collection.immutable.List.foreach(List.scala:392)
     at org.scalatest.tools.Runner$.doRunRunRunDaDoRunRun(Runner.scala:2557)
   




> 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