pabrahamusa commented on issue #6431: URL: https://github.com/apache/incubator-pinot/issues/6431#issuecomment-770946372
@siddharthteotia, we can go through this and I am sure we can get this fixed. Also the fix you provided last week is working as expected for ~100K rows and thanks a lot for that. From my preliminary testing query search performance appears same for both text index and inverted index. it is just the NRT lag that have the diff. The queries I tried with inverted index is with term query or exact match i.e ``` select * from mytable where attr_one='value1' and attr_two = 'value2' order by timemillis desc ``` Unfortunately I cannot use this inverted index search as my requirement is to make a proper text search on a column. As I am migrating from Elastic Search I can use the Lucene index regex patterns supported by pinot text index which makes things easier for me. ---------------------------------------------------------------- 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. 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
