#general
@kautsshukla: Hello, If I add a new column in “primaryKeyColumns” in schema, How much time it would take to create indexing for the new column ?
@g.kishore: is this for upsert use case?
@kautsshukla: no
@g.kishore: primaryKeyColumns is only for upsert use case. If you want to add other indexes, you can simply update the table config and invoke reloadSegments api
@g.kishore:
@kautsshukla: My table is Realtime table without upsert that means i can’t update primary index. Is it I have to re ingest the whole data again and create schema again
@kautsshukla: ?
@g.kishore: No, you dont have to
@g.kishore: please take a look at the doc link I sent you
@kautsshukla: Just schma change and upload segemnts will work for me ?
@kautsshukla: ok
@g.kishore: not upload, its reload. its just asking the servers to reload the segment during which it will generate missing indices
@kautsshukla: ok thanks …
#feat-presto-connector
@highering.ai: @highering.ai has joined the channel
#docs
@highering.ai: @highering.ai has joined the channel
#community
@highering.ai: @highering.ai has joined the channel
#announcements
@highering.ai: @highering.ai has joined the channel
#minion-improvements
@laxman: Will give a try.
@npawar: Btw the PR for offheap has been merged
@laxman: Yes Neha. Noticed that. But deploying and testing main branch is bit difficult for me even on test clusters. I will cherry pick this into 0.7.1 and test it
#complex-type-support
@amrish.k.lal: @g.kishore in continuation of what we discussed earlier, this is the existing query: `select jsoncolumn,json_extract_scalar(jsoncolumn, '$.person.companies[*].name', 'STRING') from jsontable where id = 106` which produces the results: `{"person":{"name":"daffy duck","companies":[{"name":"n1","title":"t1"},{"name":"n2","title":"t2"}]}}, ["n1","n2"]` What we would like to do is to rewrite this query from user query: `select jsoncolumn.person.companies[*].name from jsontable where id = 106` I believe by "unnesting" you are referring to the fact that `["n1","n2"]` could be separate rows in Pinot? Also, for JSON storage support, we had briefly looked at BSON format (mongodb), JSON2 (derivative of BSON used in postgres), and
@g.kishore: I was referring to a different query/requirement
--------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org
