Hello Team, when I set alias in a query, it fails ...
# troubleshooting
j
Hello Team, when I set alias in a query, it fails : select c.CustomerID from customer c limit 10 . The error is : [ { "errorCode": 190, "message": "TableDoesNotExistError" } ] While one without alias succeeds: select CustomerID from customer limit 10 Can someone please help understand what is wrong in the query with alias?
k
AFAIK Pinot only supports column alias, table alias is not supported. Tagging @Mayank to confirm.
j
I was going through the dimTables design documentation @ https://docs.google.com/document/d/1InWmxbRqwcqIakzvoEWHLxtX4XR9H5L01256EbAUHV8/edit#heading=h.4fdahkl28gtb and table alias is used in the sample Pinot queries in the document.
m
Yes correct
j
@Mayank Do you mean table alias is not supported?
m
Yes
👍 1
j
It makes sense if there is no join support as there is no possibility of column name conflict.