Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen

PMeinshausen/nGram.sql

Created September 29, 2014 03:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save PMeinshausen/8825bd898126ab5d7788 to your computer and use it in GitHub Desktop.
Save PMeinshausen/8825bd898126ab5d7788 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
nGram.sql
--Syntax (version 1.3)
SELECT *
FROM nGram
(
ON {table_name | view_name | (query)}
TEXT_COLUMN('column_name')
[DELIMITER('delimiter_regular_expression')]
GRAMS(gram_number)
[OVERLAPPING({'true'|'false'})]
[CASE_INSENSITIVE({'true'|'false'})]
[PUNCTUATION('punctuation_regular_expression')]
RESET('reset_regular_expression')
[TOTAL]
[TOTAL_COUNT_COLUMN_NAME]
[ACCUMULATE('column_name [, ...]')]
[NGRAM_COLUMN_NAME('column_name')]
[COUNT_COLUMN_NAME('column_name')]
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment