This message was deleted.
# troubleshootings
Slackbot
03/17/2023, 6:28 AMThis message was deleted.
b
Brandon Tan
03/17/2023, 6:40 AMPlease check out this thread: https://apachedruidworkspace.slack.com/archives/C0303FDCZEZ/p1677667532432889
e
enes topuz
03/17/2023, 7:02 AMHi @Akhila Mukka, thank you for your response but i have already tried those solutions and didn’t work unfortunately 😞
a
Akhila Mukka
03/17/2023, 7:53 AM@enes topuz val jdbcDF = spark.read.format("jdbc").option("url", "jdbcavaticaremote:url=http://broker:8082/druid/v2/sql/avatica/").option("dbtable", "druid.wikipedia").load()
Akhila Mukka
03/17/2023, 7:54 AMwith this i am able to get the below output jdbcDF: org.apache.spark.sql.DataFrame = [__time: timestamp, isRobot: string ... 22 more fields]
e
enes topuz
03/17/2023, 8:00 AMi am getting below error with your command :
Caused by: com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException: Unrecognized field “rpcMetadata” (class org.apache.calcite.avatica.remote.Service$CloseConnectionResponse), not marked as ignorable (0 known properties: ])
Which version of avatica jar you are using ?
a
Akhila Mukka
03/17/2023, 8:01 AMavatica-1.8.0.jar
Akhila Mukka
03/17/2023, 8:01 AM./bin/spark-shell --driver-class-path avatica-1.8.0.jar --jars avatica-1.8.0.jar
👍 1
Akhila Mukka
03/17/2023, 8:02 AMscala> val jdbcDF = spark.read.format("jdbc").option("url", "jdbcavaticaremote:url=http://broker:8082/druid/v2/sql/avatica/").option("dbtable", "wikipedia").load()
jdbcDF: org.apache.spark.sql.DataFrame = [__time: timestamp, isRobot: string ... 22 more fields]
e
enes topuz
03/17/2023, 8:06 AMThank you @Akhila Mukka i could get the same output as you and show the dataframe
a
Akhila Mukka
03/17/2023, 8:09 AMgood to know that it helped.