You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by xi...@apache.org on 2019/06/11 20:26:45 UTC
[incubator-pinot] 01/01: Adding example of querying BYTES column
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 <fx...@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-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org