Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 4C90F200B12 for ; Sun, 12 Jun 2016 10:33:37 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 4B0E5160A2C; Sun, 12 Jun 2016 08:33:37 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 4B44E160A06 for ; Sun, 12 Jun 2016 10:33:35 +0200 (CEST) Received: (qmail 2855 invoked by uid 500); 12 Jun 2016 08:33:34 -0000 Mailing-List: contact commits-help@calcite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@calcite.apache.org Delivered-To: mailing list commits@calcite.apache.org Received: (qmail 2846 invoked by uid 99); 12 Jun 2016 08:33:34 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 12 Jun 2016 08:33:34 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id E10B81805EA for ; Sun, 12 Jun 2016 08:33:33 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.373 X-Spam-Level: *** X-Spam-Status: No, score=3.373 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, MANY_SPAN_IN_TEXT=2.999, RP_MATCHES_RCVD=-1.426] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id q0SQ5so2MUVW for ; Sun, 12 Jun 2016 08:33:26 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 4D11B5F24A for ; Sun, 12 Jun 2016 08:33:26 +0000 (UTC) Received: from svn01-us-west.apache.org (svn.apache.org [10.41.0.6]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 49A94E079E for ; Sun, 12 Jun 2016 08:33:25 +0000 (UTC) Received: from svn01-us-west.apache.org (localhost [127.0.0.1]) by svn01-us-west.apache.org (ASF Mail Server at svn01-us-west.apache.org) with ESMTP id 68ABF3A0331 for ; Sun, 12 Jun 2016 08:33:24 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Subject: svn commit: r1747967 [2/4] - in /calcite/site: community/ css/ docs/ Date: Sun, 12 Jun 2016 08:33:23 -0000 To: commits@calcite.apache.org From: jhyde@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20160612083324.68ABF3A0331@svn01-us-west.apache.org> archived-at: Sun, 12 Jun 2016 08:33:37 -0000 Modified: calcite/site/docs/adapter.html URL: http://svn.apache.org/viewvc/calcite/site/docs/adapter.html?rev=1747967&r1=1747966&r2=1747967&view=diff ============================================================================== --- calcite/site/docs/adapter.html (original) +++ calcite/site/docs/adapter.html Sun Jun 12 08:33:22 2016 @@ -128,6 +128,10 @@ + + + + @@ -170,6 +174,10 @@ + + + + @@ -212,6 +220,10 @@ + + + + @@ -261,6 +273,10 @@ + + + + @@ -303,6 +319,10 @@ + + + + @@ -345,6 +365,10 @@ + + + + @@ -394,6 +418,10 @@ + + + + @@ -436,6 +464,10 @@ + + + + @@ -478,6 +510,10 @@ + + + + @@ -520,6 +556,10 @@ + + + + @@ -569,6 +609,10 @@ + + + + @@ -611,6 +655,10 @@ + + + + @@ -653,6 +701,10 @@ + + + + @@ -702,6 +754,10 @@ + + + + @@ -744,6 +800,10 @@ + + + + @@ -786,6 +846,10 @@ + + + + @@ -828,6 +892,10 @@ + + + + @@ -852,6 +920,7 @@ presenting the data as tables within a s
  • Cassandra adapter (calcite-cassandra)
  • CSV adapter (example/csv)
  • Druid adapter (calcite-druid)
    • +
  • Elasticsearch adapter (calcite-elasticsearch)
  • JDBC adapter (part of calcite-core)
  • MongoDB adapter (calcite-mongodb)
  • Spark adapter (calcite-spark)
    • @@ -888,7 +957,7 @@ Connections can be local or remote (JSON as implemented by Avatica’s ConnectStringParser.)

    -

    JDBC connect string parameters

    +

    JDBC connect string parameters

    @@ -903,6 +972,10 @@ as implemented by Avatica’s + + + + @@ -939,6 +1012,14 @@ as implemented by Avatica’s + + + + + + + + @@ -957,6 +1038,40 @@ as implemented by Avatica’s
    Whether identifiers are matched case-sensitively. If not specified, value from lex is used.
    conformanceSQL conformance level. Values: “default” (the default, similar to “pragmatic_2003”), “oracle_10”, “pragmatic_99”, “pragmatic_2003”, “strict_92”, “strict_99”, “strict_2003”.
    createMaterializations Whether Calcite should create materializations. Default false.
    Name of initial schema.
    schemaFactorySchema factory. The name of a class that implements SchemaFactory and has a public default constructor or an INSTANCE constant. Ignored if model is specified.
    schemaTypeSchema type. Value must be “MAP” (the default), “JDBC”, or “CUSTOM” (implicit if schemaFactory is specified). Ignored if model is specified.
    spark Specifies whether Spark should be used as the engine for processing that cannot be pushed to the source system. If false (the default), Calcite generates code that implements the Enumerable interface.
    +

    To make a connection to a single schema based on a built-in schema type, you don’t need to specify +a model. For example,

    + +

    jdbc:calcite:schemaType=JDBC; schema.jdbcUser=SCOTT; schema.jdbcPassword=TIGER; schema.jdbcUrl=jdbc:hsqldb:res:foodmart

    + +

    creates a connection with a schema mapped via the JDBC schema adapter to the foodmart database.

    + +

    Similarly, you can connect to a single schema based on a user-defined schema adapter. +For example,

    + +

    jdbc:calcite:schemaFactory=org.apache.calcite.adapter.cassandra.CassandraSchemaFactory; schema.host=localhost; schema.keyspace=twissandra

    + +

    makes a connection to the Cassandra adapter, equivalent to writing the following model file:

    + +

    ```json +{ + “version”: “1.0”, + “defaultSchema”: “foodmart”, + “schemas”: [ + { + type: ‘custom’, + name: ‘twissandra’, + factory: ‘org.apache.calcite.adapter.cassandra.CassandraSchemaFactory’, + operand: { + host: ‘localhost’, + keyspace: ‘twissandra’ + } + } + ] +}

    + +

    ```

    + +

    Note how each key in the operand section appears with a schema. prefix in the connect string.

    @@ -1008,6 +1123,7 @@ as implemented by Avatica’s + @@ -1059,6 +1175,14 @@ as implemented by Avatica’s + + + + + + + +
  • Background
    • @@ -1066,6 +1190,7 @@ as implemented by Avatica’s + @@ -1145,6 +1270,14 @@ as implemented by Avatica’s + + + + + + + +
  • Tutorial
    • @@ -1152,6 +1285,7 @@ as implemented by Avatica’s + @@ -1178,6 +1312,7 @@ as implemented by Avatica’s + @@ -1192,6 +1327,7 @@ as implemented by Avatica’s + @@ -1263,6 +1399,14 @@ as implemented by Avatica’s + + + + + + + +
  • Streaming
    • @@ -1270,6 +1414,7 @@ as implemented by Avatica’s + @@ -1325,6 +1470,14 @@ as implemented by Avatica’s + + + + + + + +
  • Lattices
    • @@ -1340,6 +1493,7 @@ as implemented by Avatica’s + @@ -1363,6 +1517,10 @@ as implemented by Avatica’s + + + +
  • Overview
    • @@ -1370,6 +1528,7 @@ as implemented by Avatica’s + @@ -1401,6 +1560,10 @@ as implemented by Avatica’s + + + +
  • Roadmap
    • @@ -1408,6 +1571,7 @@ as implemented by Avatica’s + @@ -1427,6 +1591,10 @@ as implemented by Avatica’s + + + +
  • JSON Reference
    • @@ -1434,6 +1602,7 @@ as implemented by Avatica’s + @@ -1461,6 +1630,10 @@ as implemented by Avatica’s + + + +
  • Protobuf Reference
    • @@ -1476,6 +1649,7 @@ as implemented by Avatica’s + @@ -1543,6 +1717,14 @@ as implemented by Avatica’s + + + + + + + +
  • SQL language
    • @@ -1550,6 +1732,7 @@ as implemented by Avatica’s + @@ -1609,6 +1792,14 @@ as implemented by Avatica’s + + + + + + + +
  • JSON models
    • @@ -1616,6 +1807,7 @@ as implemented by Avatica’s + @@ -1663,6 +1855,14 @@ as implemented by Avatica’s + + + + + + + +
  • HOWTO
    • @@ -1678,13 +1878,10 @@ as implemented by Avatica’s - - - - + @@ -1721,16 +1918,6 @@ as implemented by Avatica’s -
  • History
    • - - - - - - - - - @@ -1743,30 +1930,17 @@ as implemented by Avatica’s +
  • History
    • + + + - - - - - - - - - - - - - - - - + - - - + @@ -1791,16 +1965,6 @@ as implemented by Avatica’s -
  • Powered By Calcite
    • - - - - - - - - - @@ -1845,26 +2009,17 @@ as implemented by Avatica’s +
  • Powered By Calcite
    • + + + - - - - - - - - - - - - + - - - + @@ -1877,12 +2032,14 @@ as implemented by Avatica’s - +
  • API
    • + + @@ -1963,6 +2120,11 @@ as implemented by Avatica’s + + + +
  • Test API
    • + Modified: calcite/site/docs/algebra.html URL: http://svn.apache.org/viewvc/calcite/site/docs/algebra.html?rev=1747967&r1=1747966&r2=1747967&view=diff ============================================================================== --- calcite/site/docs/algebra.html (original) +++ calcite/site/docs/algebra.html Sun Jun 12 08:33:22 2016 @@ -128,6 +128,10 @@ + + + + @@ -170,6 +174,10 @@ + + + + @@ -212,6 +220,10 @@ + + + + @@ -261,6 +273,10 @@ + + + + @@ -303,6 +319,10 @@ + + + + @@ -345,6 +365,10 @@ + + + + @@ -394,6 +418,10 @@ + + + + @@ -436,6 +464,10 @@ + + + + @@ -478,6 +510,10 @@ + + + + @@ -520,6 +556,10 @@ + + + + @@ -569,6 +609,10 @@ + + + + @@ -611,6 +655,10 @@ + + + + @@ -653,6 +701,10 @@ + + + + @@ -702,6 +754,10 @@ + + + + @@ -744,6 +800,10 @@ + + + + @@ -786,6 +846,10 @@ + + + + @@ -828,6 +892,10 @@ + + + + @@ -1404,6 +1472,7 @@ added to the stack.

    + @@ -1455,6 +1524,14 @@ added to the stack.

    + + + + + + + +
  • Background
    • @@ -1462,6 +1539,7 @@ added to the stack.

    + @@ -1541,6 +1619,14 @@ added to the stack.

    + + + + + + + +
  • Tutorial
    • @@ -1548,6 +1634,7 @@ added to the stack.

    + @@ -1574,6 +1661,7 @@ added to the stack.

    + @@ -1588,6 +1676,7 @@ added to the stack.

    + @@ -1659,6 +1748,14 @@ added to the stack.

    + + + + + + + +
  • Streaming
    • @@ -1666,6 +1763,7 @@ added to the stack.

    + @@ -1721,6 +1819,14 @@ added to the stack.

    + + + + + + + +
  • Lattices
    • @@ -1736,6 +1842,7 @@ added to the stack.

    + @@ -1759,6 +1866,10 @@ added to the stack.

    + + + +
  • Overview
    • @@ -1766,6 +1877,7 @@ added to the stack.

    + @@ -1797,6 +1909,10 @@ added to the stack.

    + + + +
  • Roadmap
    • @@ -1804,6 +1920,7 @@ added to the stack.

    + @@ -1823,6 +1940,10 @@ added to the stack.

    + + + +
  • JSON Reference
    • @@ -1830,6 +1951,7 @@ added to the stack.

    + @@ -1857,6 +1979,10 @@ added to the stack.

    + + + +
  • Protobuf Reference
    • @@ -1872,6 +1998,7 @@ added to the stack.

    + @@ -1939,6 +2066,14 @@ added to the stack.

    + + + + + + + +
  • SQL language
    • @@ -1946,6 +2081,7 @@ added to the stack.

    + @@ -2005,6 +2141,14 @@ added to the stack.

    + + + + + + + +
  • JSON models
    • @@ -2012,6 +2156,7 @@ added to the stack.

    + @@ -2059,6 +2204,14 @@ added to the stack.

    + + + + + + + +
  • HOWTO
    • @@ -2074,17 +2227,10 @@ added to the stack.

    - - - - - - - - + @@ -2117,16 +2263,6 @@ added to the stack.

    -
  • History
    • - - - - - - - - - @@ -2143,26 +2279,17 @@ added to the stack.

    +
  • History
    • + + + - - - - - - - - - - - - + - - - + @@ -2187,16 +2314,6 @@ added to the stack.

    -
  • Powered By Calcite
    • - - - - - - - - - @@ -2241,26 +2358,17 @@ added to the stack.

    +
  • Powered By Calcite
    • + + + - - - - - - - - - - - - + - - - + @@ -2273,12 +2381,14 @@ added to the stack.

    - +
  • API
    • + + @@ -2359,6 +2469,11 @@ added to the stack.

    + + + +
  • Test API
    • + Modified: calcite/site/docs/avatica_json_reference.html URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_json_reference.html?rev=1747967&r1=1747966&r2=1747967&view=diff ============================================================================== --- calcite/site/docs/avatica_json_reference.html (original) +++ calcite/site/docs/avatica_json_reference.html Sun Jun 12 08:33:22 2016 @@ -128,6 +128,10 @@ + + + + @@ -170,6 +174,10 @@ + + + + @@ -212,6 +220,10 @@ + + + + @@ -261,6 +273,10 @@ + + + + @@ -303,6 +319,10 @@ + + + + @@ -345,6 +365,10 @@ + + + + @@ -394,6 +418,10 @@ + + + + @@ -436,6 +464,10 @@ + + + + @@ -478,6 +510,10 @@ + + + + @@ -520,6 +556,10 @@ + + + + @@ -569,6 +609,10 @@ + + + + @@ -611,6 +655,10 @@ + + + + @@ -653,6 +701,10 @@ + + + + @@ -702,6 +754,10 @@ + + + + @@ -744,6 +800,10 @@ + + + + @@ -786,6 +846,10 @@ + + + + @@ -828,6 +892,10 @@ + + + + @@ -1843,6 +1911,7 @@ SQL or by a DatabaseMetaData operation w + @@ -1894,6 +1963,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • Background
    • @@ -1901,6 +1978,7 @@ SQL or by a DatabaseMetaData operation w + @@ -1980,6 +2058,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • Tutorial
    • @@ -1987,6 +2073,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2013,6 +2100,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2027,6 +2115,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2098,6 +2187,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • Streaming
    • @@ -2105,6 +2202,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2160,6 +2258,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • Lattices
    • @@ -2175,6 +2281,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2198,6 +2305,10 @@ SQL or by a DatabaseMetaData operation w + + + +
  • Overview
    • @@ -2205,6 +2316,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2236,6 +2348,10 @@ SQL or by a DatabaseMetaData operation w + + + +
  • Roadmap
    • @@ -2243,6 +2359,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2262,6 +2379,10 @@ SQL or by a DatabaseMetaData operation w + + + +
  • JSON Reference
    • @@ -2269,6 +2390,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2296,6 +2418,10 @@ SQL or by a DatabaseMetaData operation w + + + +
  • Protobuf Reference
    • @@ -2311,6 +2437,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2378,6 +2505,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • SQL language
    • @@ -2385,6 +2520,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2444,6 +2580,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • JSON models
    • @@ -2451,6 +2595,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2498,6 +2643,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • HOWTO
    • @@ -2513,17 +2666,10 @@ SQL or by a DatabaseMetaData operation w - - - - - - - - + @@ -2556,16 +2702,6 @@ SQL or by a DatabaseMetaData operation w -
  • History
    • - - - - - - - - - @@ -2582,26 +2718,17 @@ SQL or by a DatabaseMetaData operation w +
  • History
    • + + + - - - - - - - - - - - - + - - - + @@ -2626,16 +2753,6 @@ SQL or by a DatabaseMetaData operation w -
  • Powered By Calcite
    • - - - - - - - - - @@ -2680,26 +2797,17 @@ SQL or by a DatabaseMetaData operation w +
  • Powered By Calcite
    • + + + - - - - - - - - - - - - + - - - + @@ -2712,12 +2820,14 @@ SQL or by a DatabaseMetaData operation w - +
  • API
    • + + @@ -2798,6 +2908,11 @@ SQL or by a DatabaseMetaData operation w + + + +
  • Test API
    • + Modified: calcite/site/docs/avatica_overview.html URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_overview.html?rev=1747967&r1=1747966&r2=1747967&view=diff ============================================================================== --- calcite/site/docs/avatica_overview.html (original) +++ calcite/site/docs/avatica_overview.html Sun Jun 12 08:33:22 2016 @@ -128,6 +128,10 @@ + + + + @@ -170,6 +174,10 @@ + + + + @@ -212,6 +220,10 @@ + + + + @@ -261,6 +273,10 @@ + + + + @@ -303,6 +319,10 @@ + + + + @@ -345,6 +365,10 @@ + + + + @@ -394,6 +418,10 @@ + + + + @@ -436,6 +464,10 @@ + + + + @@ -478,6 +510,10 @@ + + + + @@ -520,6 +556,10 @@ + + + + @@ -569,6 +609,10 @@ + + + + @@ -611,6 +655,10 @@ + + + + @@ -653,6 +701,10 @@ + + + + @@ -702,6 +754,10 @@ + + + + @@ -744,6 +800,10 @@ + + + + @@ -786,6 +846,10 @@ + + + + @@ -828,6 +892,10 @@ + + + + @@ -1022,6 +1090,7 @@ At some point Avatica could become a sep + @@ -1073,6 +1142,14 @@ At some point Avatica could become a sep + + + + + + + +
  • Background
    • @@ -1080,6 +1157,7 @@ At some point Avatica could become a sep + @@ -1159,6 +1237,14 @@ At some point Avatica could become a sep + + + + + + + +
  • Tutorial
    • @@ -1166,6 +1252,7 @@ At some point Avatica could become a sep + @@ -1192,6 +1279,7 @@ At some point Avatica could become a sep + @@ -1206,6 +1294,7 @@ At some point Avatica could become a sep + @@ -1277,6 +1366,14 @@ At some point Avatica could become a sep + + + + + + + +
  • Streaming
    • @@ -1284,6 +1381,7 @@ At some point Avatica could become a sep + @@ -1339,6 +1437,14 @@ At some point Avatica could become a sep + + + + + + + +
  • Lattices
    • @@ -1354,6 +1460,7 @@ At some point Avatica could become a sep + @@ -1377,6 +1484,10 @@ At some point Avatica could become a sep + + + +
  • Overview
    • @@ -1384,6 +1495,7 @@ At some point Avatica could become a sep + @@ -1415,6 +1527,10 @@ At some point Avatica could become a sep + + + +
  • Roadmap
    • @@ -1422,6 +1538,7 @@ At some point Avatica could become a sep + @@ -1441,6 +1558,10 @@ At some point Avatica could become a sep + + + +
  • JSON Reference
    • @@ -1448,6 +1569,7 @@ At some point Avatica could become a sep + @@ -1475,6 +1597,10 @@ At some point Avatica could become a sep + + + +
  • Protobuf Reference
    • @@ -1490,6 +1616,7 @@ At some point Avatica could become a sep + @@ -1557,6 +1684,14 @@ At some point Avatica could become a sep + + + + + + + +
  • SQL language
    • @@ -1564,6 +1699,7 @@ At some point Avatica could become a sep + @@ -1623,6 +1759,14 @@ At some point Avatica could become a sep + + + + + + + +
  • JSON models
    • @@ -1630,6 +1774,7 @@ At some point Avatica could become a sep + @@ -1677,6 +1822,14 @@ At some point Avatica could become a sep + + + + + + + +
  • HOWTO
    • @@ -1692,17 +1845,10 @@ At some point Avatica could become a sep - - - - - - - - + @@ -1735,16 +1881,6 @@ At some point Avatica could become a sep -
  • History
    • - - - - - - - - - @@ -1761,26 +1897,17 @@ At some point Avatica could become a sep +
  • History
    • + + + - - - - - - - - - - - - + - - - + @@ -1805,16 +1932,6 @@ At some point Avatica could become a sep -
  • Powered By Calcite
    • - - - - - - - - - @@ -1859,26 +1976,17 @@ At some point Avatica could become a sep +
  • Powered By Calcite
    • + + + - - - - - - - - - - - - + - - - + @@ -1891,12 +1999,14 @@ At some point Avatica could become a sep - +
  • API
    • + + @@ -1977,6 +2087,11 @@ At some point Avatica could become a sep + + + +
  • Test API
    • + Modified: calcite/site/docs/avatica_protobuf_reference.html URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_protobuf_reference.html?rev=1747967&r1=1747966&r2=1747967&view=diff ============================================================================== --- calcite/site/docs/avatica_protobuf_reference.html (original) +++ calcite/site/docs/avatica_protobuf_reference.html Sun Jun 12 08:33:22 2016 @@ -128,6 +128,10 @@ + + + + @@ -170,6 +174,10 @@ + + + + @@ -212,6 +220,10 @@ + + + + @@ -261,6 +273,10 @@ + + + + @@ -303,6 +319,10 @@ + + + + @@ -345,6 +365,10 @@ + + + + @@ -394,6 +418,10 @@ + + + + @@ -436,6 +464,10 @@ + + + + @@ -478,6 +510,10 @@ + + + + @@ -520,6 +556,10 @@ + + + + @@ -569,6 +609,10 @@ + + + + @@ -611,6 +655,10 @@ + + + + @@ -653,6 +701,10 @@ + + + + @@ -702,6 +754,10 @@ + + + + @@ -744,6 +800,10 @@ + + + + @@ -786,6 +846,10 @@ + + + + @@ -828,6 +892,10 @@ + + + + @@ -1907,6 +1975,7 @@ SQL or by a DatabaseMetaData operation w + @@ -1958,6 +2027,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • Background
    • @@ -1965,6 +2042,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2044,6 +2122,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • Tutorial
    • @@ -2051,6 +2137,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2077,6 +2164,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2091,6 +2179,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2162,6 +2251,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • Streaming
    • @@ -2169,6 +2266,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2224,6 +2322,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • Lattices
    • @@ -2239,6 +2345,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2262,6 +2369,10 @@ SQL or by a DatabaseMetaData operation w + + + +
  • Overview
    • @@ -2269,6 +2380,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2300,6 +2412,10 @@ SQL or by a DatabaseMetaData operation w + + + +
  • Roadmap
    • @@ -2307,6 +2423,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2326,6 +2443,10 @@ SQL or by a DatabaseMetaData operation w + + + +
  • JSON Reference
    • @@ -2333,6 +2454,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2360,6 +2482,10 @@ SQL or by a DatabaseMetaData operation w + + + +
  • Protobuf Reference
    • @@ -2375,6 +2501,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2442,6 +2569,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • SQL language
    • @@ -2449,6 +2584,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2508,6 +2644,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • JSON models
    • @@ -2515,6 +2659,7 @@ SQL or by a DatabaseMetaData operation w + @@ -2562,6 +2707,14 @@ SQL or by a DatabaseMetaData operation w + + + + + + + +
  • HOWTO
    • @@ -2577,17 +2730,10 @@ SQL or by a DatabaseMetaData operation w - - - - - - - - + @@ -2620,16 +2766,6 @@ SQL or by a DatabaseMetaData operation w -
  • History
    • - - - - - - - - - @@ -2646,26 +2782,17 @@ SQL or by a DatabaseMetaData operation w +
  • History
    • + + + - - - - - - - - - - - - + - - - + @@ -2690,16 +2817,6 @@ SQL or by a DatabaseMetaData operation w -
  • Powered By Calcite
    • - - - - - - - - - @@ -2744,26 +2861,17 @@ SQL or by a DatabaseMetaData operation w +
  • Powered By Calcite
    • + + + - - - - - - - - - - - - + - - - + @@ -2776,12 +2884,14 @@ SQL or by a DatabaseMetaData operation w - +
  • API
    • + + @@ -2862,6 +2972,11 @@ SQL or by a DatabaseMetaData operation w + + + +
  • Test API
    • + Modified: calcite/site/docs/avatica_roadmap.html URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_roadmap.html?rev=1747967&r1=1747966&r2=1747967&view=diff ============================================================================== --- calcite/site/docs/avatica_roadmap.html (original) +++ calcite/site/docs/avatica_roadmap.html Sun Jun 12 08:33:22 2016 @@ -128,6 +128,10 @@ + + + + @@ -170,6 +174,10 @@ + + + + @@ -212,6 +220,10 @@ + + + + @@ -261,6 +273,10 @@ + + + + @@ -303,6 +319,10 @@ + + + + @@ -345,6 +365,10 @@ + + + + @@ -394,6 +418,10 @@ + + + + @@ -436,6 +464,10 @@ + + + + @@ -478,6 +510,10 @@ + + + + @@ -520,6 +556,10 @@ + + + + @@ -569,6 +609,10 @@ + + + + @@ -611,6 +655,10 @@ + + + + @@ -653,6 +701,10 @@ + + + + @@ -702,6 +754,10 @@ + + + + @@ -744,6 +800,10 @@ + + + + @@ -786,6 +846,10 @@ + + + + @@ -828,6 +892,10 @@ + + + + @@ -944,6 +1012,7 @@ + @@ -995,6 +1064,14 @@ + + + + + + + +
  • Background
    • @@ -1002,6 +1079,7 @@ + @@ -1081,6 +1159,14 @@ + + + + + + + +
  • Tutorial
    • @@ -1088,6 +1174,7 @@ + @@ -1114,6 +1201,7 @@ + @@ -1128,6 +1216,7 @@ + @@ -1199,6 +1288,14 @@ + + + + + + + +
  • Streaming
    • @@ -1206,6 +1303,7 @@ + @@ -1261,6 +1359,14 @@ + + + + + + + +
  • Lattices
    • @@ -1276,6 +1382,7 @@ + @@ -1299,6 +1406,10 @@ + + + +
  • Overview
    • @@ -1306,6 +1417,7 @@ + @@ -1337,6 +1449,10 @@ + + + +
  • Roadmap
    • @@ -1344,6 +1460,7 @@ + @@ -1363,6 +1480,10 @@ + + + +
  • JSON Reference
    • @@ -1370,6 +1491,7 @@ + @@ -1397,6 +1519,10 @@ + + + +
  • Protobuf Reference
    • @@ -1412,6 +1538,7 @@ + @@ -1479,6 +1606,14 @@ + + + + + + + +
  • SQL language
    • @@ -1486,6 +1621,7 @@ + @@ -1545,6 +1681,14 @@ + + + + + + + +
  • JSON models
    • @@ -1552,6 +1696,7 @@ + @@ -1599,6 +1744,14 @@ + + + + + + + +
  • HOWTO
    • @@ -1614,17 +1767,10 @@ - - - - - - - - + @@ -1657,16 +1803,6 @@ -
  • History
    • - - - - - - - - - @@ -1683,26 +1819,17 @@ +
  • History
    • + + + - - - - - - - - - - - - + - - - + @@ -1727,16 +1854,6 @@ -
  • Powered By Calcite
    • - - - - - - - - - @@ -1781,26 +1898,17 @@ +
  • Powered By Calcite
    • + + + - - - - - - - - - - - - + - - - + @@ -1813,12 +1921,14 @@ - +
  • API
    • + + @@ -1899,6 +2009,11 @@ + + + +
  • Test API
    • + Modified: calcite/site/docs/cassandra_adapter.html URL: http://svn.apache.org/viewvc/calcite/site/docs/cassandra_adapter.html?rev=1747967&r1=1747966&r2=1747967&view=diff ============================================================================== --- calcite/site/docs/cassandra_adapter.html (original) +++ calcite/site/docs/cassandra_adapter.html Sun Jun 12 08:33:22 2016 @@ -128,6 +128,10 @@ + + + + @@ -170,6 +174,10 @@ + + + + @@ -212,6 +220,10 @@ + + + + @@ -261,6 +273,10 @@ + + + + @@ -303,6 +319,10 @@ + + + + @@ -345,6 +365,10 @@ + + + + @@ -394,6 +418,10 @@ + + + + @@ -436,6 +464,10 @@ + + + + @@ -478,6 +510,10 @@ + + + + @@ -520,6 +556,10 @@ + + + + @@ -569,6 +609,10 @@ + + + + @@ -611,6 +655,10 @@ + + + + @@ -653,6 +701,10 @@ + + + + @@ -702,6 +754,10 @@ + + + + @@ -744,6 +800,10 @@ + + + + @@ -786,6 +846,10 @@ + + + + @@ -828,6 +892,10 @@ + + + + @@ -994,6 +1062,7 @@ prove useful.

    + @@ -1045,6 +1114,14 @@ prove useful.

    + + + + + + + +
  • Background
    • @@ -1052,6 +1129,7 @@ prove useful.

    + @@ -1131,6 +1209,14 @@ prove useful.

    + + + + + + + +
  • Tutorial
    • @@ -1138,6 +1224,7 @@ prove useful.

    + @@ -1164,6 +1251,7 @@ prove useful.

    + @@ -1178,6 +1266,7 @@ prove useful.

    + @@ -1249,6 +1338,14 @@ prove useful.

    + + + + + + + +
  • Streaming
    • @@ -1256,6 +1353,7 @@ prove useful.

    + @@ -1311,6 +1409,14 @@ prove useful.

    + + + + + + + +
  • Lattices
    • @@ -1326,6 +1432,7 @@ prove useful.

    + @@ -1349,6 +1456,10 @@ prove useful.

    + + + +
  • Overview
    • @@ -1356,6 +1467,7 @@ prove useful.

    + @@ -1387,6 +1499,10 @@ prove useful.

    + + + +
  • Roadmap
    • @@ -1394,6 +1510,7 @@ prove useful.

    + @@ -1413,6 +1530,10 @@ prove useful.

    + + + +
  • JSON Reference
    • @@ -1420,6 +1541,7 @@ prove useful.

    + @@ -1447,6 +1569,10 @@ prove useful.

    + + + +
  • Protobuf Reference
    • @@ -1462,6 +1588,7 @@ prove useful.

    + @@ -1529,6 +1656,14 @@ prove useful.

    + + + + + + + +
  • SQL language
    • @@ -1536,6 +1671,7 @@ prove useful.

    + @@ -1595,6 +1731,14 @@ prove useful.

    + + + + + + + +
  • JSON models
    • @@ -1602,6 +1746,7 @@ prove useful.

    + @@ -1649,6 +1794,14 @@ prove useful.

    + + + + + + + +
  • HOWTO
    • @@ -1664,17 +1817,10 @@ prove useful.

    - - - - - - - - + @@ -1707,16 +1853,6 @@ prove useful.

    -
  • History
    • - - - - - - - - - @@ -1733,26 +1869,17 @@ prove useful.

    +
  • History
    • + + + - - - - - - - - - - - - + - - - + @@ -1777,16 +1904,6 @@ prove useful.

    -
  • Powered By Calcite
    • - - - - - - - - - @@ -1831,26 +1948,17 @@ prove useful.

    +
  • Powered By Calcite
    • + + + - - - - - - - - - - - - + - - - + @@ -1863,12 +1971,14 @@ prove useful.

    - +
  • API
    • + + @@ -1949,6 +2059,11 @@ prove useful.

    + + + +
  • Test API
    • + Modified: calcite/site/docs/druid_adapter.html URL: http://svn.apache.org/viewvc/calcite/site/docs/druid_adapter.html?rev=1747967&r1=1747966&r2=1747967&view=diff ============================================================================== --- calcite/site/docs/druid_adapter.html (original) +++ calcite/site/docs/druid_adapter.html Sun Jun 12 08:33:22 2016 @@ -128,6 +128,10 @@ + + + + @@ -170,6 +174,10 @@ + + + + @@ -212,6 +220,10 @@ + + + + @@ -261,6 +273,10 @@ + + + + @@ -303,6 +319,10 @@ + + + + @@ -345,6 +365,10 @@ + + + + @@ -394,6 +418,10 @@ + + + + @@ -436,6 +464,10 @@ + + + + @@ -478,6 +510,10 @@ + + + + @@ -520,6 +556,10 @@ + + + + @@ -569,6 +609,10 @@ + + + + @@ -611,6 +655,10 @@ + + + + @@ -653,6 +701,10 @@ + + + + @@ -702,6 +754,10 @@ + + + + @@ -744,6 +800,10 @@ + + + + @@ -786,6 +846,10 @@ + + + + @@ -828,6 +892,10 @@ + + + + @@ -871,7 +939,8 @@ of the Druid adapter.

    "name": "wiki", "factory": "org.apache.calcite.adapter.druid.DruidSchemaFactory", "operand": { - "url": "http://localhost:8082/druid/v2/?pretty" + "url": "http://localhost:8082", + "coordinatorUrl": "http://localhost:8081" }, "tables": [ { @@ -956,7 +1025,7 @@ as follows:

    sqlline>

    That query shows the top 5 countries of origin of wiki page edits -on 2015-09-12 (the date covered by the wikiticker data set).

    +on 2015-09-12 (the date covered by the wikiticker data set).

    Now let’s see how the query was evaluated:

    @@ -988,6 +1057,96 @@ into a single Druid data set called â€

    You can access it via the druid/src/test/resources/druid-foodmart-model.json model.

    +

    Simplifying the model

    + +

    If less metadata is provided in the model, the Druid adapter can discover +it automatically from Druid. Here is a schema equivalent to the previous one +but with dimensions, metrics and timestampColumn removed:

    + +
    {
+  "version": "1.0",
+  "defaultSchema": "wiki",
+  "schemas": [
+    {
+      "type": "custom",
+      "name": "wiki",
+      "factory": "org.apache.calcite.adapter.druid.DruidSchemaFactory",
+      "operand": {
+        "url": "http://localhost:8082",
+        "coordinatorUrl": "http://localhost:8081"
+      },
+      "tables": [
+        {
+          "name": "wiki",
+          "factory": "org.apache.calcite.adapter.druid.DruidTableFactory",
+          "operand": {
+            "dataSource": "wikiticker",
+            "interval": "1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z"
+          }
+        }
+      ]
+    }
+  ]
+}
    + +

    Calcite dispatches a +segmentMetadataQuery +to Druid to discover the columns of the table. +Now, let’s take out the tables element:

    + +
    {
+  "version": "1.0",
+  "defaultSchema": "wiki",
+  "schemas": [
+    {
+      "type": "custom",
+      "name": "wiki",
+      "factory": "org.apache.calcite.adapter.druid.DruidSchemaFactory",
+      "operand": {
+        "url": "http://localhost:8082",
+        "coordinatorUrl": "http://localhost:8081"
+      }
+    }
+  ]
+}
    + +

    Calcite discovers the “wikiticker” data source via the +/druid/coordinator/v1/metadata/datasources +REST call. Now that the “wiki” table element is removed, the table is called +“wikiticker”. Any other data sources present in Druid will also appear as +tables.

    + +

    Our model is now a single schema based on a custom schema factory with only two +operands, so we can +dispense with the model +and supply the operands as part of the connect string:

    + +
      jdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory; schema.url=http://localhost:8082; schema.coordinatorUrl=http://localhost:8081
    + +

    In fact, those are the +default values of the operands, +so we can omit them:

    + +
      jdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory
    + +

    Now, we can connect to sqlline using a very simple connect string, and list +the available tables:

    + +
    $ ./sqlline
+sqlline> !connect jdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory admin admin
+sqlline> !tables
++-----------+-------------+------------+--------------+
+| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE   |
++-----------+-------------+------------+--------------+
+|           | adhoc       | foodmart   | TABLE        |
+|           | adhoc       | wikiticker | TABLE        |
+|           | metadata    | COLUMNS    | SYSTEM_TABLE |
+|           | metadata    | TABLES     | SYSTEM_TABLE |
++-----------+-------------+------------+--------------+
    + +

    We see the two system tables (TABLES and COLUMNS), +and the two tables in Druid (foodmart and wikiticker).

    + @@ -1060,6 +1219,7 @@ into a single Druid data set called †+ @@ -1111,6 +1271,14 @@ into a single Druid data set called †+ + + + + + + +
  • Background
    • @@ -1118,6 +1286,7 @@ into a single Druid data set called †+ @@ -1197,6 +1366,14 @@ into a single Druid data set called †+ + + + + + + +
  • Tutorial
    • @@ -1204,6 +1381,7 @@ into a single Druid data set called †+ @@ -1230,6 +1408,7 @@ into a single Druid data set called †+ @@ -1244,6 +1423,7 @@ into a single Druid data set called †+ @@ -1315,6 +1495,14 @@ into a single Druid data set called †+ + + + + + + +
  • Streaming
    • @@ -1322,6 +1510,7 @@ into a single Druid data set called †+ @@ -1377,6 +1566,14 @@ into a single Druid data set called †+ + + + + + + +
  • Lattices
    • @@ -1392,6 +1589,7 @@ into a single Druid data set called †+ @@ -1415,6 +1613,10 @@ into a single Druid data set called †+ + + +
  • Overview
    • @@ -1422,6 +1624,7 @@ into a single Druid data set called †+ @@ -1453,6 +1656,10 @@ into a single Druid data set called †+ + + +
  • Roadmap
    • @@ -1460,6 +1667,7 @@ into a single Druid data set called †+ @@ -1479,6 +1687,10 @@ into a single Druid data set called †+ + + +
  • JSON Reference
    • @@ -1486,6 +1698,7 @@ into a single Druid data set called †+ @@ -1513,6 +1726,10 @@ into a single Druid data set called †+ + + +
  • Protobuf Reference
    • @@ -1528,6 +1745,7 @@ into a single Druid data set called †+ @@ -1595,6 +1813,14 @@ into a single Druid data set called †+ + + + + + + +
  • SQL language
    • @@ -1602,6 +1828,7 @@ into a single Druid data set called †+ @@ -1661,6 +1888,14 @@ into a single Druid data set called †+ + + + + + + +
  • JSON models
    • @@ -1668,6 +1903,7 @@ into a single Druid data set called †+ @@ -1715,6 +1951,14 @@ into a single Druid data set called †+ + + + + + + +
  • HOWTO
    • @@ -1730,17 +1974,10 @@ into a single Druid data set called †- - - - - - - - + @@ -1773,16 +2010,6 @@ into a single Druid data set called †-
  • History
    • - - - - - - - - - @@ -1799,26 +2026,17 @@ into a single Druid data set called †+
  • History
    • + + + - - - - - - - - - - - - + - - - + @@ -1843,16 +2061,6 @@ into a single Druid data set called †-
  • Powered By Calcite
    • - - - - - - - - - @@ -1897,26 +2105,17 @@ into a single Druid data set called †+
  • Powered By Calcite
    • + + + - - - - - - - - - - - - + - - - + @@ -1929,12 +2128,14 @@ into a single Druid data set called †- +
  • API
    • + + @@ -2015,6 +2216,11 @@ into a single Druid data set called †+ + + +
  • Test API
    • +