drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill git commit: Drill 1.11 doc update - pstore in-memory query profiles
Date Tue, 08 Aug 2017 21:13:22 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages 14e387530 -> 391767258


Drill 1.11 doc update - pstore in-memory query profiles


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/39176725
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/39176725
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/39176725

Branch: refs/heads/gh-pages
Commit: 391767258a7bd454bc9bb1b1fa8d702424b4d803
Parents: 14e3875
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Tue Aug 8 14:12:12 2017 -0700
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Tue Aug 8 14:12:12 2017 -0700

----------------------------------------------------------------------
 .../040-persistent-configuration-storage.md       | 18 ++++++++++--------
 _docs/sql-reference/030-lexical-structure.md      |  4 ++--
 2 files changed, 12 insertions(+), 10 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/39176725/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
b/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
index 32ba5dd..f98fa8e 100644
--- a/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
+++ b/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
@@ -1,16 +1,12 @@
 ---
 title: "Persistent Configuration Storage"
-date:  
+date: 2017-08-08 21:12:16 UTC
 parent: "Configuration Options"
 ---
 Drill stores persistent configuration data in a persistent configuration store
-(PStore). This data is encoded in JSON or Protobuf format. Drill can use the
-local file system or a distributed file system, such as HDFS, to store this data. The data
-stored in a PStore includes state information for storage plugins, query
-profiles, and ALTER SYSTEM settings. The default type of PStore configured
-depends on the Drill installation mode.
+(PStore). The data stored in a PStore includes state information for storage plugins, query
profiles, and ALTER SYSTEM settings. This data is encoded in JSON or Protobuf format. Drill
can write this data to the local file system or a distributed file system, such as HDFS. As
of Drill 1.11, Drill can store query profiles in memory instead of writing the profiles to
disk.
 
-The following table provides the persistent storage mode for each of the Drill
+The default type of PStore configured depends on the Drill installation mode. The following
table provides the persistent storage mode for each of the Drill
 modes:
 
 | Mode        | Description                                                             
                                                                                         
                  |
@@ -66,5 +62,11 @@ override.conf.`
 	      "hbase.zookeeper.property.clientPort": "2181"
 	      }
 	    }
-	  },
+	  },  
+
+##Storing Query Profiles in Memory
+As of Drill 1.11, Drill can store query profiles in memory instead of writing them to disk.
For sub-second queries, writing the query profile to disk is expensive due to the interactions
with the file system. You can enable the `drill.exec.profiles.store.inmemory` option in the
drill-override.conf file if you want Drill to store the profiles for sub-second queries in
memory instead of writing the profiles to disk. When you enable this option, Drill stores
the profiles in memory for as long as the drillbit runs. When the drillbit restarts, the profiles
no longer exist. You can set the maximum number of most recent profiles to retain in memory
through the `drill.exec.profiles.store.capacity` option. The default is set to 1000. See [Start-Up
Options]({{site.baseurl}}/docs/start-up-options/) for more information.  
+
+{% include startnote.html %}You must restart Drill after you enable the `drill.exec.profiles.store.inmemory`
option.{% include endnote.html %} 
+
 

http://git-wip-us.apache.org/repos/asf/drill/blob/39176725/_docs/sql-reference/030-lexical-structure.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/030-lexical-structure.md b/_docs/sql-reference/030-lexical-structure.md
index 7314258..3e5a3f2 100644
--- a/_docs/sql-reference/030-lexical-structure.md
+++ b/_docs/sql-reference/030-lexical-structure.md
@@ -1,6 +1,6 @@
 ---
 title: "Lexical Structure"
-date: 2017-08-07 19:02:56 UTC
+date: 2017-08-08 21:12:19 UTC
 parent: "SQL Reference"
 ---
 
@@ -120,7 +120,7 @@ The following table lists the supported identifier quotes with their correspondi
 |----------------------|-----------------------------------------------------------------------|
 | Back ticks           | 'GRAVE   ACCENT' (U+0060)                                      
      |
 | Double quotes        | 'QUOTATION   MARK' (U+0022)                                    
      |
-| Square brackets      | 'LEFT   SQUARE BRACKET' (U+005B) and 'RIGHT SQUARE BRACKET' (U+005D;)
|  
+| Square brackets      | 'LEFT   SQUARE BRACKET' (U+005B) and 'RIGHT SQUARE BRACKET' (U+005D)
|  
 
 Alternatively, you can set the type of identifier using the `quoting_identifiers` property
in the jdbc connection URL, as shown:  
  


Mime
View raw message