Will update you guys on what we finally come up with.

Jim, your inputs are much appreciated. Thanks!

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.

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...

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...

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

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 ...

Found the working odbc.ini setup