From 387d66633c3333dcb2bdcdfde57732f61c8b5f37 Mon Sep 17 00:00:00 2001 From: Ryo Shibayama Date: Mon, 15 Aug 2016 14:27:38 +0900 Subject: Add a language switcher --- changelog.html | 4 ++++ contact.html | 4 ++++ examples.html | 4 ++++ future-ideas.html | 4 ++++ implementation.html | 4 ++++ index.html | 4 ++++ install.html | 4 ++++ ja/contact.html | 4 ++++ ja/examples.html | 4 ++++ ja/future-ideas.html | 4 ++++ ja/implementation.html | 4 ++++ ja/index.html | 4 ++++ ja/install.html | 4 ++++ ja/limitations.html | 4 ++++ ja/rationale.html | 4 ++++ ja/requirements.html | 4 ++++ ja/tutorial.html | 4 ++++ limitations.html | 4 ++++ rationale.html | 4 ++++ requirements.html | 4 ++++ stylesheets/stylesheet.css | 6 ++++++ tutorial.html | 4 ++++ usage.html | 4 ++++ 23 files changed, 94 insertions(+) diff --git a/changelog.html b/changelog.html index f96d82c..2002085 100644 --- a/changelog.html +++ b/changelog.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/contact.html b/contact.html index 9a59591..2a77a09 100644 --- a/contact.html +++ b/contact.html @@ -18,6 +18,10 @@
+ View on GitHub diff --git a/examples.html b/examples.html index 46ee515..3f55e2a 100644 --- a/examples.html +++ b/examples.html @@ -18,6 +18,10 @@
+ View on GitHub diff --git a/future-ideas.html b/future-ideas.html index 66e5c37..8c76bf4 100644 --- a/future-ideas.html +++ b/future-ideas.html @@ -18,6 +18,10 @@
+ View on GitHub diff --git a/implementation.html b/implementation.html index 7f0e7a3..8459a89 100644 --- a/implementation.html +++ b/implementation.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/index.html b/index.html index c897e6f..2962c34 100644 --- a/index.html +++ b/index.html @@ -20,6 +20,10 @@
+ View on GitHub diff --git a/install.html b/install.html index da25f8c..a03a533 100644 --- a/install.html +++ b/install.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/ja/contact.html b/ja/contact.html index 575aa17..8f68bb1 100644 --- a/ja/contact.html +++ b/ja/contact.html @@ -18,6 +18,10 @@
+ View on GitHub diff --git a/ja/examples.html b/ja/examples.html index d1b902f..36bdf98 100644 --- a/ja/examples.html +++ b/ja/examples.html @@ -18,6 +18,10 @@
+ View on GitHub diff --git a/ja/future-ideas.html b/ja/future-ideas.html index be7d87a..7fe23ef 100644 --- a/ja/future-ideas.html +++ b/ja/future-ideas.html @@ -18,6 +18,10 @@
+ View on GitHub diff --git a/ja/implementation.html b/ja/implementation.html index 728c1c8..dcf7b0f 100644 --- a/ja/implementation.html +++ b/ja/implementation.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/ja/index.html b/ja/index.html index aec6688..d817d47 100644 --- a/ja/index.html +++ b/ja/index.html @@ -20,6 +20,10 @@
+ View on GitHub diff --git a/ja/install.html b/ja/install.html index ad167ce..9199707 100644 --- a/ja/install.html +++ b/ja/install.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/ja/limitations.html b/ja/limitations.html index 76f5b32..6854b43 100644 --- a/ja/limitations.html +++ b/ja/limitations.html @@ -18,6 +18,10 @@
+ View on GitHub diff --git a/ja/rationale.html b/ja/rationale.html index 44f418a..4762c89 100644 --- a/ja/rationale.html +++ b/ja/rationale.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/ja/requirements.html b/ja/requirements.html index 059f86f..b972d4f 100644 --- a/ja/requirements.html +++ b/ja/requirements.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/ja/tutorial.html b/ja/tutorial.html index 17dd82c..9e51c4b 100644 --- a/ja/tutorial.html +++ b/ja/tutorial.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/limitations.html b/limitations.html index 26d557c..cfb1a86 100644 --- a/limitations.html +++ b/limitations.html @@ -18,6 +18,10 @@
+ View on GitHub diff --git a/rationale.html b/rationale.html index 784a49a..bac0320 100644 --- a/rationale.html +++ b/rationale.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/requirements.html b/requirements.html index 1c4aedb..d76c0f0 100644 --- a/requirements.html +++ b/requirements.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/stylesheets/stylesheet.css b/stylesheets/stylesheet.css index 804109d..b4039c6 100644 --- a/stylesheets/stylesheet.css +++ b/stylesheets/stylesheet.css @@ -302,6 +302,12 @@ Full-Width Styles margin: 0 auto; } +#language_switcher { + display: block; + position: absolute; + top:0; +} + #forkme_banner { display: block; position: absolute; diff --git a/tutorial.html b/tutorial.html index 9cf2ca1..d70e01e 100644 --- a/tutorial.html +++ b/tutorial.html @@ -17,6 +17,10 @@
+ View on GitHub diff --git a/usage.html b/usage.html index 26ea885..b729a35 100644 --- a/usage.html +++ b/usage.html @@ -17,6 +17,10 @@
+ View on GitHub -- cgit v1.2.3 From 92fd7cb550b1645cde3eda9d96fbbda12e93bc03 Mon Sep 17 00:00:00 2001 From: Ryo Shibayama Date: Mon, 15 Aug 2016 14:33:41 +0900 Subject: Fix indentation --- changelog.html | 386 ++++++++++++++++++------------------ contact.html | 170 ++++++++-------- examples.html | 322 +++++++++++++++--------------- future-ideas.html | 182 ++++++++--------- implementation.html | 188 +++++++++--------- index.html | 210 ++++++++++---------- install.html | 294 +++++++++++++-------------- ja/contact.html | 168 ++++++++-------- ja/examples.html | 320 +++++++++++++++--------------- ja/future-ideas.html | 150 +++++++------- ja/implementation.html | 182 ++++++++--------- ja/index.html | 206 +++++++++---------- ja/install.html | 290 +++++++++++++-------------- ja/limitations.html | 144 +++++++------- ja/rationale.html | 198 +++++++++---------- ja/requirements.html | 142 ++++++------- ja/tutorial.html | 308 ++++++++++++++--------------- ja/usage.html | 502 +++++++++++++++++++++++----------------------- limitations.html | 146 +++++++------- rationale.html | 196 +++++++++--------- requirements.html | 144 +++++++------- tutorial.html | 314 ++++++++++++++--------------- usage.html | 528 ++++++++++++++++++++++++------------------------- 23 files changed, 2845 insertions(+), 2845 deletions(-) diff --git a/changelog.html b/changelog.html index 2002085..beb756b 100644 --- a/changelog.html +++ b/changelog.html @@ -1,196 +1,196 @@ - - - - - - - - Changelog - - - - - - - - -
-

General

- -

Documentation

- -

Behind the Scenes

- -

Author

- -

Social

- -
- -
-
-

-Change log

- -

Fri Dec 12 2014 Harel Ben-Attia harelba@gmail.com 1.5.0-1

- -
    -
  • Full input/output support for double-quoting fields with delimiters
    • -
  • Multiple query support in one command line, reusing previously loaded data in subsequent queries
    • -
  • Support literal SELECT statements (e.g. SELECT 5+12.5/3)
    • -
  • Full code restructuring (Internally working now using a full python API which will become public in the next version)
    • -
  • Added sha1 function. You can use 'select sha1(c3) from ...'
    • -
  • Solved the following bugs/pull-requests: - -
      -
    • #10 - Reuse of previously loaded data when running multiple queries in one command line
      • -
    • #64 - Full support for literal SELECT statements without a table (e.g. SELECT 5+12.5)
      • -
    • #56 - Proper double quote handling, including multiline fields, for both input and output according to csv standards
      • -
    • #69 - Added warning suppression when the user provides a specific column count
      • -
    • #40 - Code restructuring cleaning, creating a full python API (will be published in the next version)
      • -
    • #60 - Fixed RPM packaging
      • -
    • #68 - UTF-8 with BOM files cause column naming issues
      • -
    • #63 - Unicode string support in regexp function
      • -
    -
    • -
- - -

Sat Jun 14 2014 Harel Ben-Attia harelba@gmail.com 1.4.0-1

- -
    -
  • 2.5x Speed improvement due to better bulk loading
    • -
  • Output header support
    • -
  • Additional control over query and output encodings
    • -
  • Solved the following bugs/pull-requests: - -
      -
    • -#52 - Bulk insert for better performance
      • -
    • -#55 - Use UUID to ensure temporary table names don't clash
      • -
    • -#53 - Allow easier tab-delimited output
      • -
    • -#51 - Ensure that generated temp tables are uniquely named
      • -
    • -#50 - Copyright peculiarities
      • -
    • -#49 - Add option to output fieldnames as headers
      • -
    • -#48 - PEP 8
      • -
    • -#47 - Prevent regexp from failing when field value is null
      • -
    • -#41 - Fix project folder structure
      • -
    • -#32 - Remove duplicated definitions, and PEP8-ing (tabs to spaces, etc.)
      • -
    • -#29 - RPM: Source0 should be a URL
      • -
    • -#54 - Fix query encoding (data encoding works well)
      • -
    -
    • -

Thu Mar 03 2014 Harel Ben-Attia harelba@gmail.com 1.3.0-1

- -
    -
  • Added column name and type detection (Use -A to see name/type analysis for the specified input)
    • -
  • Added support for multiple parsing modes - Relaxed, Strict and Fluffy (old, backward compatible behavior)
    • -
  • Fixed tab delimition parameter problem
    • -
  • More improvements to error reporting
    • -
  • Added a test suite, in preparation for refactoring
    • -
  • Solves the following bugs/pull-requests: - -
      -
    • -#7 - Dynamic column count support
      • -
    • -#8 - Column name inference from input containing a header row
      • -
    • -#9 - Automatic column type inference using sample data
      • -
    • -#30 - Header lines option does nothing
      • -
    • -#33 - Last column should allow for spaces?
      • -
    • -#35 - Add q.bat
      • -
    • -#38 - Problem with whitespace delimiter
      • -
    • -#43 - using the -t flag stopped the header flag from working
      • -
    • -#44 - Space in column name on TAB separated values break q
      • -
    -
    • -
  • Breaking changes: - -
      -
    • Changed -H behavior so it's now a flag an not a parameter (1 line always)
      • -
    • Removed support for multi-char delimiters
      • -
    -
    • -

Sat Feb 22 2014 Harel Ben-Attia harelba@gmail.com 1.2.0-1

- -
    -
  • Support for quoted fields in CSVs
    • -
  • Some bug fixes
    • -
  • Improved error reporting
    • -

Thu Feb 20 2014 Harel Ben-Attia harelba@gmail.com 1.1.7-1

- -
    -
  • Better error reporting
    • -
  • Fixed python invocation for non stanard locations
    • -
  • Added man page
    • -

Tue Jan 7 2014 Harel Ben-Attia harelba@gmail.com 1.0.0-1

- -
    -
  • Initial version - tag was needed for homebrew formula
    • -
- - - - + + + + + + + + Changelog + + + + + + + + +
+

General

+ +

Documentation

+ +

Behind the Scenes

+ +

Author

+ +

Social

+ +
+ +
+
+

+ Change log

+ +

Fri Dec 12 2014 Harel Ben-Attia harelba@gmail.com 1.5.0-1

+ +
    +
  • Full input/output support for double-quoting fields with delimiters
    • +
  • Multiple query support in one command line, reusing previously loaded data in subsequent queries
    • +
  • Support literal SELECT statements (e.g. SELECT 5+12.5/3)
    • +
  • Full code restructuring (Internally working now using a full python API which will become public in the next version)
    • +
  • Added sha1 function. You can use 'select sha1(c3) from ...'
    • +
  • Solved the following bugs/pull-requests: + +
      +
    • #10 - Reuse of previously loaded data when running multiple queries in one command line
      • +
    • #64 - Full support for literal SELECT statements without a table (e.g. SELECT 5+12.5)
      • +
    • #56 - Proper double quote handling, including multiline fields, for both input and output according to csv standards
      • +
    • #69 - Added warning suppression when the user provides a specific column count
      • +
    • #40 - Code restructuring cleaning, creating a full python API (will be published in the next version)
      • +
    • #60 - Fixed RPM packaging
      • +
    • #68 - UTF-8 with BOM files cause column naming issues
      • +
    • #63 - Unicode string support in regexp function
      • +
    +
    • +
+ + +

Sat Jun 14 2014 Harel Ben-Attia harelba@gmail.com 1.4.0-1

+ +
    +
  • 2.5x Speed improvement due to better bulk loading
    • +
  • Output header support
    • +
  • Additional control over query and output encodings
    • +
  • Solved the following bugs/pull-requests: + +
      +
    • + #52 - Bulk insert for better performance
      • +
    • + #55 - Use UUID to ensure temporary table names don't clash
      • +
    • + #53 - Allow easier tab-delimited output
      • +
    • + #51 - Ensure that generated temp tables are uniquely named
      • +
    • + #50 - Copyright peculiarities
      • +
    • + #49 - Add option to output fieldnames as headers
      • +
    • + #48 - PEP 8
      • +
    • + #47 - Prevent regexp from failing when field value is null
      • +
    • + #41 - Fix project folder structure
      • +
    • + #32 - Remove duplicated definitions, and PEP8-ing (tabs to spaces, etc.)
      • +
    • + #29 - RPM: Source0 should be a URL
      • +
    • + #54 - Fix query encoding (data encoding works well)
      • +
    +
    • +

Thu Mar 03 2014 Harel Ben-Attia harelba@gmail.com 1.3.0-1

+ +
    +
  • Added column name and type detection (Use -A to see name/type analysis for the specified input)
    • +
  • Added support for multiple parsing modes - Relaxed, Strict and Fluffy (old, backward compatible behavior)
    • +
  • Fixed tab delimition parameter problem
    • +
  • More improvements to error reporting
    • +
  • Added a test suite, in preparation for refactoring
    • +
  • Solves the following bugs/pull-requests: + +
      +
    • + #7 - Dynamic column count support
      • +
    • + #8 - Column name inference from input containing a header row
      • +
    • + #9 - Automatic column type inference using sample data
      • +
    • + #30 - Header lines option does nothing
      • +
    • + #33 - Last column should allow for spaces?
      • +
    • + #35 - Add q.bat
      • +
    • + #38 - Problem with whitespace delimiter
      • +
    • + #43 - using the -t flag stopped the header flag from working
      • +
    • + #44 - Space in column name on TAB separated values break q
      • +
    +
    • +
  • Breaking changes: + +
      +
    • Changed -H behavior so it's now a flag an not a parameter (1 line always)
      • +
    • Removed support for multi-char delimiters
      • +
    +
    • +

Sat Feb 22 2014 Harel Ben-Attia harelba@gmail.com 1.2.0-1

+ +
    +
  • Support for quoted fields in CSVs
    • +
  • Some bug fixes
    • +
  • Improved error reporting
    • +

Thu Feb 20 2014 Harel Ben-Attia harelba@gmail.com 1.1.7-1

+ +
    +
  • Better error reporting
    • +
  • Fixed python invocation for non stanard locations
    • +
  • Added man page
    • +

Tue Jan 7 2014 Harel Ben-Attia harelba@gmail.com 1.0.0-1

+ +
    +
  • Initial version - tag was needed for homebrew formula
    • +
+ + + + diff --git a/contact.html b/contact.html index 2a77a09..b1677dd 100644 --- a/contact.html +++ b/contact.html @@ -1,94 +1,94 @@ - - - - - - - - - Contact - - - - - - - - -
-

General

- -

Documentation

- -

Behind the Scenes

- -

Author

- -

Social

- - -
- -
-
- -

-Contact

- -

Any feedback/suggestions/complaints regarding this tool would be much appreciated. Contributions are most welcome as well, of course.

- -

if you have any suggestions regarding the web site itself, please send them to me as well

- -

Harel Ben-Attia, harelba@gmail.com, @harelba on Twitter

+ + + + + + + + + Contact + + + + + + + + +
+

General

+ +

Documentation

+ +

Behind the Scenes

+ +

Author

+ +

Social

+ + +
+ +
+
+ +

+ Contact

+ +

Any feedback/suggestions/complaints regarding this tool would be much appreciated. Contributions are most welcome as well, of course.

+ +

if you have any suggestions regarding the web site itself, please send them to me as well

+ +

Harel Ben-Attia, harelba@gmail.com, @harelba on Twitter

- + diff --git a/examples.html b/examples.html index 3f55e2a..d6d6cd2 100644 --- a/examples.html +++ b/examples.html @@ -1,206 +1,206 @@ - - - - - - - - - Examples - - - - - - - - -
-

General

- -

Documentation

- -

Behind the Scenes

- -

Author

- -

Social

- - -
- -
-
-

Examples

-

The -H flag in the examples below signifies that the file has a header row which is used for naming columns.

-

The -t flag is just a shortcut for saying that the file is a tab-separated file (any delimiter is supported - Use the -d flag).

- -

Queries are given using upper case for clarity, but actual query keywords such as SELECT and WHERE are not really case sensitive.

+ + + + + + + + + Examples + + + + + + + + +
+

General

+ +

Documentation

+ +

Behind the Scenes

+ +

Author

+ +

Social

+ + +
+ +
+
+

Examples

+

The -H flag in the examples below signifies that the file has a header row which is used for naming columns.

+

The -t flag is just a shortcut for saying that the file is a tab-separated file (any delimiter is supported - Use the -d flag).

+ +

Queries are given using upper case for clarity, but actual query keywords such as SELECT and WHERE are not really case sensitive.

- + -

+

-

Example 1 - COUNT DISTINCT values of specific field (uuid of clicks data)

+

Example 1 - COUNT DISTINCT values of specific field (uuid of clicks data)

-
q -H -t "SELECT COUNT(DISTINCT(uuid)) FROM ./clicks.csv"
-
+ 
q -H -t "SELECT COUNT(DISTINCT(uuid)) FROM ./clicks.csv"
+
-

Output 1:

+

Output 1:

-
229
-
+ 
229
+
-

+

-

Example 2 - Filter numeric data, controlling ORDERing and LIMITing output

+

Example 2 - Filter numeric data, controlling ORDERing and LIMITing output

-

Note that q understands that the column is numeric and filters according to its numeric value (real numeric value comparison, not string comparison).

+

Note that q understands that the column is numeric and filters according to its numeric value (real numeric value comparison, not string comparison).

-
q -H -t "SELECT request_id,score FROM ./clicks.csv WHERE score > 0.7 ORDER BY score DESC LIMIT 5"
-
+ 
q -H -t "SELECT request_id,score FROM ./clicks.csv WHERE score > 0.7 ORDER BY score DESC LIMIT 5"
+
-

Output 2:

+

Output 2:

-
2cfab5ceca922a1a2179dc4687a3b26e    1.0
-f6de737b5aa2c46a3db3208413a54d64    0.986665809568
-766025d25479b95a224bd614141feee5    0.977105183282
-2c09058a1b82c6dbcf9dc463e73eddd2    0.703255121794
-
+ 
2cfab5ceca922a1a2179dc4687a3b26e    1.0
+        f6de737b5aa2c46a3db3208413a54d64    0.986665809568
+        766025d25479b95a224bd614141feee5    0.977105183282
+        2c09058a1b82c6dbcf9dc463e73eddd2    0.703255121794
+
-

+

-

Example 3 - Illustrate GROUP BY

+

Example 3 - Illustrate GROUP BY

-
q -t -H "SELECT hashed_source_machine,count(*) FROM ./clicks.csv GROUP BY hashed_source_machine"
-
+ 
q -t -H "SELECT hashed_source_machine,count(*) FROM ./clicks.csv GROUP BY hashed_source_machine"
+
-

Output 3:

+

Output 3:

-
47d9087db433b9ba.domain.com 400000
-
+ 
47d9087db433b9ba.domain.com 400000
+
-

+

-

Example 4 - More complex GROUP BY (group by time expression)

+

Example 4 - More complex GROUP BY (group by time expression)

-
q -t -H "SELECT strftime('%H:%M',date_time) hour_and_minute,count(*) FROM ./clicks.csv GROUP BY hour_and_minute"
-
+ 
q -t -H "SELECT strftime('%H:%M',date_time) hour_and_minute,count(*) FROM ./clicks.csv GROUP BY hour_and_minute"
+
-

Output 4:

+

Output 4:

-
07:00   138148
-07:01   140026
-07:02   121826
-
+ 
07:00   138148
+        07:01   140026
+        07:02   121826
+
-

-

Example 5 - Read input from standard input

+

+

Example 5 - Read input from standard input

-

Calculates the total size per user/group in the /tmp subtree.

+

Calculates the total size per user/group in the /tmp subtree.

-
sudo find /tmp -ls | q "SELECT c5,c6,sum(c7)/1024.0/1024 AS total FROM - GROUP BY c5,c6 ORDER BY total desc"
-
+ 
sudo find /tmp -ls | q "SELECT c5,c6,sum(c7)/1024.0/1024 AS total FROM - GROUP BY c5,c6 ORDER BY total desc"
+
-

Output 5:

+

Output 5:

-
mapred hadoop   304.00390625
-root   root     8.0431451797485
-smith  smith    4.34389972687
-
+ 
mapred hadoop   304.00390625
+        root   root     8.0431451797485
+        smith  smith    4.34389972687
+
-

-

Example 6 - Use column names from header row

+

+

Example 6 - Use column names from header row

-

Calculate the top 3 user ids with the largest number of owned processes, sorted in descending order.

-

Note the usage of the autodetected column name UID in the query.

+

Calculate the top 3 user ids with the largest number of owned processes, sorted in descending order.

+

Note the usage of the autodetected column name UID in the query.

-
ps -ef | q -H "SELECT UID,COUNT(*) cnt FROM - GROUP BY UID ORDER BY cnt DESC LIMIT 3"
-
+ 
ps -ef | q -H "SELECT UID,COUNT(*) cnt FROM - GROUP BY UID ORDER BY cnt DESC LIMIT 3"
+
-

Output 6:

+

Output 6:

-