Search found 5 matches
- Thu Oct 20, 2016 6:58 am
- Forum: Vertica SQL
- Topic: Oracle Query to Vertica Query conversion
- Replies: 1
- Views: 15397
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...
- 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: 18224
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.
- Fri Apr 22, 2016 12:17 pm
- Forum: New to Vertica SQL
- Topic: Query for de duplication
- Replies: 0
- Views: 11943
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...
- 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: 18224
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. ...
- Tue Mar 29, 2016 1:31 pm
- Forum: Vertica SQL Functions
- Topic: Vertica User defined SQL function
- Replies: 1
- Views: 17361
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...