'unable to get vDataframe for a table

I am not able to create vDataFrame in VerticaPy.

https://www.vertica.com/python/documentation_last/vdataframe/object/index.php

In my Jupyter notebook, I read a csv file

train_vdf = read_csv("train.csv")
type(train_vdf)

The train_vdf is of type vDataFrame, which is fine. read_csv also creates a table called train in v_temp_schema.

When I try to create vDataFrame directly from the temp table, I get error No table or views 'v_temp_schema' found

    vdf = vDataFrame("v_temp_schema.train")
25 type(train_vdf)
     26 train_vdf
---> 27 vdf = vDataFrame("kaggle_titanic.v_temp_schema.train")
     28 #vdf
     29 

~\Anaconda3\lib\site-packages\verticapy\vdataframe.py in __init__(self, input_relation, cursor, dsn, usecols, schema, empty)
    217             if not (usecols):
    218                 self._VERTICAPY_VARIABLES_["allcols_ind"] = len(columns)
--> 219             assert columns != [], MissingRelation("No table or views '{}' found.".format(self._VERTICAPY_VARIABLES_["input_relation"]))
    220             self._VERTICAPY_VARIABLES_["columns"] = [elem for elem in columns]
    221             for col_dtype in columns_dtype:

AssertionError: No table or views 'v_temp_schema' found.

Interestingly, I can create vDataFrame if I use some other table in public schema. Eg. this works where titanic_train_flex_view is a view I created in the database directly.

vdf = vDataFrame("titanic_train_flex_view")
vdf

Seems the issue is onlywith v_temp_view. Why can't I create vDataFrame for the temp view created by VerticaPy apis?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source