Error in Accessing v_catalog from spark
sdm
Vertica Customer
I can access various tables of my schema from spark using Vertica connector. However, when I try to access the same DB, I received the below error when trying to access v_catalog schema.
User class threw exception: java.lang.Exception: Specified relation name "v_catalog"."columns" does not exist.
at com.vertica.spark.seg.SegmentsMetaInfo$class.getSyntheticSegExpr(SegmentsMetaInfo.scala:251)
at com.vertica.spark.datasource.DefaultSource.getSyntheticSegExpr(VerticaSource.scala:15)
at com.vertica.spark.seg.SegmentsMetaInfo$class.initSegInfo(SegmentsMetaInfo.scala:50)
at com.vertica.spark.datasource.DefaultSource.initSegInfo(VerticaSource.scala:15)
at com.vertica.spark.datasource.DefaultSource.createRelation(VerticaSource.scala:40)
at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:318)
at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:223)
at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:211)
at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:167)
Answers
Hi,
It seems on your database system table access removed from the users.
Provide the below 3 system tables access to the user manually and try.
nodes, columns,configuration_parameters
I thought only DbAdmin can have access to nodes and columns table is my understanding incorrect?