Error in Accessing v_catalog from spark

sdmsdm Vertica Customer
in General Discussion

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)

Tagged:

Answers

  • krishnamrajukrishnamraju Community Edition User ✭

    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

  • rahulrahul

    I thought only DbAdmin can have access to nodes and columns table is my understanding incorrect?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...