'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 |
|---|
