I am new to Vertical. I have the above question. I would appreciate a reply in this regard. Thanks.
I mean the best way to perform division t1.c1/t2.c2. Here c1and c2are columns in tables t1 and t2 respectively.
If you want the cartesian product of the two tables (unlikely) you can simply do:
select t1.c1/t2.c2 from t1, t2;
More likely you want to join the tables, perhaps using some identifier:
select t1.c1/t2.c2 from t1 join t2 on t1.id =t2.id;
Thanks. It solved my problem. Also, I was using a join on both the tables.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.