Do Bigquery Partition decorators with snapshot change with query parameters? -
suppose used
“select title, count(*) [publicdata:samples.wikipedia@1390581599000$0-of-3] group title” and used
“select author [publicdata:samples.wikipedia@1390581599000$0-of-3] group author” am guaranteed both of these run on same dataset? or there no such guarantee since number of shards used depends on columns selected (due columnio storage)?
query parameters not affecting dataset.
so running different queries on same "snapshots" reads same data.
Comments
Post a Comment