Jim_Knicely
Administrator
Jim_Knicely Administrator
Reactions
-
Re: Need help on vsql connection in shell script.
Not exactly sure what you are trying to do, but you could just use the -c option to pass in a simple command to run, then vsql will exit. I am also using the -o option to output to a file (i.e. a log… (View Post)-1 -
Re: Function APPROXIMATE_MEDIAN(int) does not exist, or permission is denied for APPROXIMATE_MEDIAN(int)
You can also use admintools to reinstall the any package: Example: [dbadmin@localhost ~]$ admintools -t list_packages Package Description AWS Amazon Web Services Package ComplexTypes Functions for Co… (View Post)-1 -
Re: List the functions within Vertica packages
Maybe something like this? SELECT DISTINCT l.lib_name , l.description , f.schema_name function_schema , f.function_name , f.procedure_type function_type FROM user_functions f JOIN user_libraries l ON… (View Post)-1 -
Re: Does Vertica have an equivalent to MySQL's GROUP_CONCAT function?
Hi, I grabbed the code from here: https://github.com/vertica/UDx-Examples/blob/master/Java-and-C%2B%2B/AggregateFunctions/Concatenate.cpp I'm using CentOS, but I was able to compile it and create the… (View Post)-1 -
Re: Insert multiple rows with INSERT INTO
Yeah, that won't work. You could do this: dbadmin=> CREATE LOCAL TEMPORARY TABLE "iris" ("Sepal.Length" DOUBLE PRECISION, "Sepal.Width" DOUBLE PRECISION, "Petal.… (View Post)0