Search found 5 matches

by rsaveetha
Thu Oct 20, 2016 6:58 am
Forum: Vertica SQL
Topic: Oracle Query to Vertica Query conversion
Replies: 1
Views: 15116

Oracle Query to Vertica Query conversion

Hi, I am working on a DB migration project, in which the database is getting migrated from Oracle to Vertica, which also includes the conversion of PL/SQL procedures for vertica.(I am doing this in java with vertica SQL and JDBC). One of the procedure is having a query like >> "select rtrim(xmlagg(x...
by rsaveetha
Fri Apr 22, 2016 12:18 pm
Forum: New to Vertica SQL
Topic: Sample Vertica SQL with the inputs from an application
Replies: 3
Views: 17893

Re: Sample Vertica SQL with the inputs from an application

i have used a java query builder to construct the query based on the user input from the UI.
by rsaveetha
Fri Apr 22, 2016 12:17 pm
Forum: New to Vertica SQL
Topic: Query for de duplication
Replies: 0
Views: 11677

Query for de duplication

Hi, I am new to Vertica and I am working on Data Cleaning. I have a source table(raw table) which may have duplicate records. I need to filter the records based on the columns given by user(maximun upto 3 columns) and insert into a target table. I have written a query like this - INSERT INTO OUTPUTT...
by rsaveetha
Mon Apr 11, 2016 7:22 am
Forum: New to Vertica SQL
Topic: Sample Vertica SQL with the inputs from an application
Replies: 3
Views: 17893

Sample Vertica SQL with the inputs from an application

Hi, I am new to Vertica as well as SQL. I have an requirement to create a table and populate with the data from different table. The user enter these details(new table name and the source table name) in the front end application. Can you any one share me the sample query to capture the user inputs. ...
by rsaveetha
Tue Mar 29, 2016 1:31 pm
Forum: Vertica SQL Functions
Topic: Vertica User defined SQL function
Replies: 1
Views: 16950

Vertica User defined SQL function

Hi, I was creating a user defined SQL function using a create or replace function statement. My function converts a numerical value to its range ie if my input value is 213 the output should be 200-300. I have written a logic and created function. When i try to run the function, it gives me compilat...

Go to advanced search