Will update you guys on what we finally come up with.
Jim, your inputs are much appreciated. Thanks!
Search found 8 matches
- Wed Jan 29, 2014 2:37 pm
- Forum: New to Vertica SQL
- Topic: ERROR 3146: Duplicate columns in select list of projection
- Replies: 6
- Views: 11773
- Wed Jan 29, 2014 1:59 pm
- Forum: New to Vertica SQL
- Topic: ERROR 3146: Duplicate columns in select list of projection
- Replies: 6
- Views: 11773
Re: ERROR 3146: Duplicate columns in select list of projecti
Thanks Jim.
Looks good. Our mindset (was) is still leaning on how our data structures were in previous databases supported. So this is a great exercise to look at things in a more Vertica-centric view.
Looks good. Our mindset (was) is still leaning on how our data structures were in previous databases supported. So this is a great exercise to look at things in a more Vertica-centric view.
- Wed Jan 29, 2014 1:09 pm
- Forum: New to Vertica SQL
- Topic: ERROR 3146: Duplicate columns in select list of projection
- Replies: 6
- Views: 11773
Re: ERROR 3146: Duplicate columns in select list of projecti
I was answered in the Vertica forum. Let me paste the link as well as the reply. https://community.vertica.com/vertica/topics/error_3146_duplicate_columns_in_select_list_of_projection_not_allowed Hi, It is type of a pre-join projection, which doesn't allow duplicity. --(select child_id first_child_i...
- Wed Jan 29, 2014 11:20 am
- Forum: New to Vertica SQL
- Topic: ERROR 3146: Duplicate columns in select list of projection
- Replies: 6
- Views: 11773
ERROR 3146: Duplicate columns in select list of projection
Hi All, I've encountered an issue (or non-issue?) and would need some clarification: Here's how to simulate it Database: Vertica 7 (but I think same behaviour applies to other versions) create table parent ( parent_id int, description varchar(20), child01 number, child02 number ); create table child...
- Wed Oct 16, 2013 1:48 pm
- Forum: Vertica Tips, Lessons and Examples
- Topic: Other Vertica Example Database
- Replies: 4
- Views: 21878
Re: Other Vertica Example Database
Thanks Jim, I'll try to do that.
I was hoping to have sample data too, but it looks like I'll have to generate my own
I was hoping to have sample data too, but it looks like I'll have to generate my own
- Wed Oct 16, 2013 11:47 am
- Forum: Vertica Tips, Lessons and Examples
- Topic: Other Vertica Example Database
- Replies: 4
- Views: 21878
Other Vertica Example Database
Hi Guys, If we look at the old Vertica ( https://my.vertica.com/docs/4.1/HTML/Master/4314.htm ) documentation there is mention of other sample database such as Clickstream, Telecom, Retail Sales, etc. I know that we have VMart Schema (example database) available by default. I was wondering if other ...
- Wed Sep 11, 2013 8:55 am
- Forum: ODBC
- Topic: Accessing Oracle Tables from Vertica via ODBC (UnixODBC)
- Replies: 2
- Views: 18350
Re: Accessing Oracle Tables from Vertica via ODBC (UnixODBC)
Found the working odbc.ini setup
Code: Select all
[OracleDSN]
Description = Oracle 11g Driver
Driver = /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
ServerName = orcl
UserID = utlzapp_ctl
Password = oracle
Port = 1521