walterddr commented on issue #12272: URL: https://github.com/apache/pinot/issues/12272#issuecomment-1896247233
i couldn't reproduce. there are several things that needs to be fixed in order to get this right 1. your dim table is on `"primaryKeyColumns": ["id", "fact_id"]` i had to make it to just `fact_id` in order to get your query running 2. there's a chance that you saw the default null value for the results that's not joined successfully. LOOKUP is essentially a "LEFT JOIN" which will keep every row on the left table and put default null value to the columns that didn't match on the LOOKUP right table. the default value for multi-value-column is empty and the default value for int is INTEGER_MIN and the default value for string is `"null"`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
