Feedback

×

• Feedback
• Was this page helpful?*
  • Yes
  • No
• Do you have any additional feedback?
  • Yes
  • No
• Additional Feedback

Parsers

General

read_file(path[, schema, table_name, dtype, ...])

Inspects and ingests a file in CSV, Parquet, ORC, JSON, or Avro format.

---

CSV

pcsv(path[, sep, header, header_names, ...])	Parses a CSV file using flex tables.
read_csv(path[, schema, table_name, sep, ...])	Ingests a CSV file using flex tables.

---

JSON

pjson(path[, ingest_local])	Parses a JSON file using flex tables.
read_json(path[, schema, table_name, ...])	Ingests a JSON file using flex tables.

---

AVRO

read_avro(path[, schema, table_name, ...])

Ingests an AVRO file using flex tables.

---

SHP

read_shp(path[, schema, table_name])

Ingests a SHP file.

---

Pandas

pandas_to_vertica(df[, name, schema, dtype, ...])	Ingests a pandas.DataFrame into the Vertica database by creating a CSV file and then using flex tables to load the data.
read_pandas(df[, name, schema, dtype, ...])	Ingests a pandas.DataFrame into the Vertica database by creating a CSV file and then using flex tables to load the data.

---

In-memory Arrays

insert_into(table_name, data[, schema, ...])

Inserts the dataset into an existing Vertica table.

---