https://pinot.apache.org/ logo
j

jainendra tarun

07/07/2021, 2:45 PM
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

Kulbir Nijjer

07/07/2021, 3:14 PM
AFAIK Pinot only supports column alias, table alias is not supported. Tagging @Mayank to confirm.
j

jainendra tarun

07/07/2021, 3:41 PM
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

Mayank

07/07/2021, 3:45 PM
Yes correct
j

jainendra tarun

07/07/2021, 3:46 PM
@Mayank Do you mean table alias is not supported?
m

Mayank

07/07/2021, 3:46 PM
Yes
👍 1
j

jainendra tarun

07/07/2021, 3:48 PM
It makes sense if there is no join support as there is no possibility of column name conflict.