Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Error in Accessing v_catalog from spark

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)



  • 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?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.