python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - vertica

How to count changes within each column and in SQL

This is how the table is looking like: id city address steps date 1 null null a 2021-11-01 1 NY null b 2021-11-04 1 Chicago null c 2021-11-05 2 SF 33, ABC colony x 2021-12-01 2 SF 33, ...
test-img

trojan horse

sql

window-functions

vertica

Votes: 0

Answers: 2

Latest Answer

Can this work for you? WITH -- your input, do not use in query ... indata(id,city,addr,steps,dt) AS ( SELECT 1,NULL ,NULL ,'a',DATE '2021-11-01' UNION ALL SELECT 1,'NY' ,...
test-img

marcothesane

how to create table definition from csv file and also copy data at the same time

I want to load data from a csv file into Vertica. I don't want to create table and the copy data in two separate steps. Instead, I want to create the table, specify the csv file and then let vertica f...
test-img

Manu Chadha

vertica

Votes: 0

Answers: 1

Latest Answer

It's always several steps, no matter what. Use the built-in bits of Vertica: CREATE FLEX TABLE foo(); COPY foo FROM '/data/mycsvs/foo.csv' PARSER fCsvParser(); SELECT COMPUTE_FLEXTABLE_KEYS_AND_BUIL...
test-img

marcothesane

Posts

Questions

Blogs

Jobs