Search found 8 matches

by fane89
Wed Mar 21, 2018 9:13 am
Forum: Vertica SQL Functions
Topic: Calling SQL functions and not allowing to throw error.
Replies: 0
Views: 352

Calling SQL functions and not allowing to throw error.

Hello, when calling to_number() or to_timestamp() function and something goes wrong an exception is thrown. Is there a possiblity to return null instead of throwing an error? Like safe casting via ::! I thought maybe to write custom functions and catch those errors, but it cannot be done via CREATE ...
by fane89
Mon Mar 19, 2018 10:27 am
Forum: New to Vertica Database Development
Topic: Calling SQL functions and not allowing to throw error.
Replies: 0
Views: 390

Calling SQL functions and not allowing to throw error.

Hello, when calling to_number() or to_timestamp() function and something goes wrong an exception is thrown. Is there a possiblity to return null instead of throwing an error? Like safe casting via ::! I thought maybe to write custom functions and catch those errors, but it cannot be done via CREATE ...
by fane89
Fri Aug 04, 2017 10:57 am
Forum: Vertica SQL Functions
Topic: Audit specific columns
Replies: 3
Views: 717

Re: Audit specific columns

Thank You very much kind Sir :)

strange, there is nothing about it when i serach the docs - https://my.vertica.com/docs/8.1.x/HTML/ ... 8_1_0-Live
by fane89
Thu Aug 03, 2017 10:20 am
Forum: Vertica SQL Functions
Topic: Audit specific columns
Replies: 3
Views: 717

Audit specific columns

Hello,

is there a way to AUDIT (https://my.vertica.com/docs/8.1.x/HTML/ ... ight=AUDIT) just some columns from a table? Or a diffrent approach to achive this?
by fane89
Thu Aug 03, 2017 10:16 am
Forum: Vertica Data Load
Topic: Loading data via COPY to a table without ksafty.
Replies: 4
Views: 1183

Re: Loading data via COPY to a table without ksafty.

Thanks, i will look into that.
by fane89
Wed Jul 26, 2017 12:43 pm
Forum: Vertica Data Load
Topic: Loading data via COPY to a table without ksafty.
Replies: 4
Views: 1183

Re: Loading data via COPY to a table without ksafty.

Hi, I'm trying to optimize the COPY process. when loading data via COPY (using direct) to a table with ksafty=0 times are faster, then loading to table with ksafty=1 or 2. The perfect solution would be to load to a temporary table, but i need access to data between sessions. For example: Loading 10G...

Go to advanced search