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 <bbev...@maprtech.com>
Authored: Tue Aug 8 14:12:12 2017 -0700
Committer: Bridget Bevens <bbev...@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:  
  

Reply via email to