You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by sn...@apache.org on 2019/06/12 00:56:58 UTC

[incubator-pinot] branch master updated: Adding example of querying BYTES column (#4304)

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 <fx...@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-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org