Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to Process beyond 5 Computed Columns #9

Open
saklanipankaj opened this issue Jun 20, 2019 · 1 comment
Open

Unable to Process beyond 5 Computed Columns #9

saklanipankaj opened this issue Jun 20, 2019 · 1 comment
Labels

Comments

@saklanipankaj
Copy link

SELECT AVG(t2.a - t1.a) AS "avg",AVG(t2.a + t1.a) AS "avg1",
AVG(t2.a - t1.b) AS "avg2", SUM(t2.a * t1.a) AS "avg3", 
SUM(t2.a / t1.a) AS "avg4",AVG(t2.b * t1.b) AS "avg5", 
MAX(t2.b - t2.a) AS "max", MIN(t2.b - t2.a) AS "min", 
SUM(t2.a + t2.a) AS "sum", MAX(t2.a * t1.a) AS "max2", 
MIN(t2.b / t2.a) AS "min2", MAX(t2.a + t1.a) AS "max3", 
MIN(t2.b / t1.b) AS "min4", SUM(t2.a * t1.b) AS "sum4", 
SUM(t1.b - t1.b) AS "sum5"  
FROM t1, t2;

42703: column vnvmhkyhceoi.aaaaaaaaaabn.Range does not exist
Ambiguous Error is thrown after computed number of columns exceeds 5.

@cheziyi
Copy link
Member

cheziyi commented Jun 21, 2019

We will need to investigate this further.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants