Yes, you have to convert them. I use xlsx2csv to convert Excel files to CSV in Linux. See: https://pypi.org/project/xlsx2csv/ Example: [root@s18384357 dbadmin]# easy_install xlsx2csvSearching for xls… (View Post)

Did you have a semi-colon after the CREATE TABLE statement? Like this: CREATE TABLE CUSTOMERS ( C_CUSTKEY NUMBER(38,0), C_NAME VARCHAR(25), C_ADDRESS VARCHAR(40), C_NATIONKEY NUMBER(38,0), C_PHONE VA… (View Post)

One more thing, try not use the data type NUMERIC(38,0) when you can use INT instead because an INT has a smaller footprint! dbadmin=> CREATE TABLE an_int_is_smaller(c1 NUMERIC(38,0), c2 INT);CREA… (View Post)

@svijay - Inetresting. What version of Vertica are you running? See if you can size the array column appropriately. By default, they are pretty big. Example: dbadmin=> CREATE EXTERNAL TABLE custom… (View Post)

Hi, Instead of an External Table you could use a Columnar (managed) Table, then load the data using the COPY command. Example: dbadmin=> \! /home/dbadmin/cat cust.json{"id":1,"name&… (View Post)