Jim_Knicely
Administrator
-
Re: Dynamic Header Column When Exec Query
Simple answer: dbadmin=> select MAX(w1) w1, MAX(w2) w2, MAX(w3) w3 from tst.f2_view; w1 | w2 | w3----+----+---- c1 | c2 | c3(1 row) But that's not very dynamic. Or you could change the insert… (View Post)1 -
Re: Dynamic Header Column When Exec Query
@Ariel_Cary - That is a cool way to use a Flex Table! @reli - Just for fun, here is maybe another way to get what you want on the fly from vsql... dbadmin=> SELECT * FROM tst.tableA; id | code_---… (View Post)1 -
Re: DIRECT Is Now the Default Load Type
Note that this a feature of "new " databases created after installing 9.3. If you want an existing DB upgraded to 9.3 to use this feature, change the value of the DMLTargetDirect database p… (View Post)0 -
Re: Exposing Vertica log as external table for SQL access? Does anyone have a script with log parser?
Maybe this discussion is helpful? https://forum.vertica.com/discussion/239926/load-vertica-log-in-flex-table-and-also-evolve-a-regexp-function-to-identify-the-error-settings (View Post)1 -
Re: Hybrid Flex table performance vs standard table
That's an interesting use case! A quick test shows that the RAW columns does add alot of storage: dbadmin=> SELECT export_tables('', 'car_sales');… (View Post)1
