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:44 UTC
[incubator-pinot] branch fx19880617-patch-1 created (now 11c3d5d)
This is an automated email from the ASF dual-hosted git repository.
xiangfu pushed a change to branch fx19880617-patch-1
in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git.
at 11c3d5d Adding example of querying BYTES column
This branch includes the following new commits:
new 11c3d5d Adding example of querying BYTES column
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[incubator-pinot] 01/01: Adding example of querying BYTES column
Posted by xi...@apache.org.
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