Sorry! SELECT t2.*, MAX(CASE WHEN INSTR(t2.c, t1.c) >= 1 THEN 'Y' ELSE 'N' END) "Match" FROM t2 CROSS JOIN t1 GROUP BY col1, col2, col3, col4, col5, etc ORDER BY col1… (View Post)

It is the column name in the sample tables I used (T1 and T2). (View Post)

@SK21 - How are you removing nodes? MC or admintools? If either, Vertica will initiate the rebalance for you. If you are doing this manually, you have to set the nodes to be EPHEMERAL, then run the R… (View Post)

Prior the removal of nodes from an Enterprise Mode Vertica database, a process called "Rebalance" has to be run so that any data on nodes to be removed is distributed to the remaining nodes… (View Post)

Seems like the correct result is: 44267.4722222222 (View Post)