Bryan_H
Administrator
Bryan_H Administrator
Reactions
-
Re: Selecting a wildcard of virtual columns from a flex table
You can group the results and IMPLODE into a single row, or use array functions to collapse the list to an array. (View Post)1 -
Re: [WinError 2] The system cannot find the file specified
From the developers: "“pandas_to_vertica” exports the pandas to CSV first. “temp_file” is used to locate the file. If it is not defined it will create the temp file in the current directory.&quo… (View Post)1 -
Re: System table table_statistics is missing column "table_schema"
"table_statistics" is a view, you can get the definition by running: select * from vs_system_views where view_name = 'table_statistics'; then write a view that includes schema field from vs… (View Post)1 -
Re: Selecting a wildcard of virtual columns from a flex table
Consider the following flex data: d2=> select maptostring(raw) from rest; maptostring { "restaurant.name": "Bob's pizzeria", "restaurant.cuisine": "Italian"… (View Post)2 -
Re: Unable to use Vertica ODBC on Excel (Mac M1)
ARM architecture support will be available with version 12.0.4 ODBC driver, due out very soon. I will update this thread when it's released, or open a support case for direct notice when it's availab… (View Post)1