#general
@taherk77: @taherk77 has joined the channel
@tymm: Hi. I see that theres this "Segment Merge" that we can configure for pinot table.
@victoranand: @victoranand has joined the channel
@ashish: The diagram in the dictionary-encoded forward index seems to be wrong - entries with docId 3 and 4 (last two entries) point to "113" for the colA but contain dictId of 2 and 3 respectively. Shouldn't they be set to '2' just like the entries pointing to 112?
@g.kishore: Thanks for reporting... Can you share the link?
@ashish:
@g.kishore: You are right; good eyes we will have to replace the image
@ashish: Was this image generated through some tool or drawn manually?
@g.kishore: I think Omni graffle or
@ken: I have a note that the diagram(s) on the page also seemed wrong to me.
@ken: And yes, looks like something generated by OmniGraffle
@ashish: Is my understanding correct? If yes, how can fix/update the diagram?
#random
@taherk77: @taherk77 has joined the channel
@victoranand: @victoranand has joined the channel
#troubleshooting
@taherk77: @taherk77 has joined the channel
@victoranand: @victoranand has joined the channel
#pinot-dev
@amrish.k.lal: I am trying out JSON_MATCH functionality using JsonIndexQuickStart. First I ran the query `select actor from githubEvents limit 1` which produced the result: `{"id":18542751,"login":"LimeVista","display_login":"LimeVista","gravatar_id":"","url":"
@steotia: Can you try count(*) for the same json match filter.? Does it return 1? Also try using json_extract_scalar (actor, '$.id', 'STRING') from ... json_match ....
@amrish.k.lal: `select count(*) from githubEvents WHERE JSON_MATCH(actor, 'login = ''LimeVista''')` produces empty result. I am wondering if there is an issue with Json index search here? select `json_extract_scalar(actor,'$.id', 'STRING')` from githubEvents limit 10 works and returns results. `select count(*) from githubEvents WHERE json_extract_scalar(actor,'$.id', 'STRING') = '18542751'` also works
@amrish.k.lal: Seems like there is a small bug in QueryContextConverterUtils.java. I will create a PR with fix and SQL level test cases.
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
