This is an automated email from the ASF dual-hosted git repository. xiangfu pushed a commit to branch fx19880617-patch-1 in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git
commit 11c3d5de78909007db46521c8965eb71e4e7f68c Author: Xiang Fu <fx19880...@gmail.com> AuthorDate: Tue Jun 11 13:26:37 2019 -0700 Adding example of querying BYTES column --- docs/pql_examples.rst | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) diff --git a/docs/pql_examples.rst b/docs/pql_examples.rst index 17f0359..f0599ef 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 ----------------- @@ -236,7 +245,6 @@ Supported transform functions The ``VALUEIN`` transform function is especially useful when the same multi-valued column is both filtering column and grouping column. *e.g.* ``VALUEIN(mvColumn, 3, 5, 15)`` - Differences with SQL -------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org