This is an automated email from the ASF dual-hosted git repository. snlee pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git
The following commit(s) were added to refs/heads/master by this push: new baca816 Adding example of querying BYTES column (#4304) baca816 is described below commit baca8165fd5a5b09bb60d2a0460d9b139b808e52 Author: Xiang Fu <fx19880...@gmail.com> AuthorDate: Tue Jun 11 17:56:52 2019 -0700 Adding example of querying BYTES column (#4304) * Adding example of querying BYTES column * Update pql_examples.rst --- docs/pql_examples.rst | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) diff --git a/docs/pql_examples.rst b/docs/pql_examples.rst index 17f0359..72fc243 100644 --- a/docs/pql_examples.rst +++ b/docs/pql_examples.rst @@ -118,8 +118,17 @@ The examples below demonstrate the use of UDFs SELECT count(*) FROM myTable GROUP BY timeConvert(timeColumnName, 'SECONDS', 'DAYS') - SELECT count(*) FROM myTable - GROUP BY div(tim +Examples with BYTES column +-------------------------- + +Pinot supports queries on BYTES column using HEX string. The query response also uses hex string to represent bytes value. + +E.g. the query below fetches all the rows for a given UID. + +.. code-block:: sql + + SELECT * FROM myTable + WHERE UID = "c8b3bce0b378fc5ce8067fc271a34892" PQL Specification ----------------- --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org