# HQL syntax highlighting
# by Michal Lorek <michal.lorek@gmail.com>
caseinsensitive
context default
# Keywords
keyword whole TRUE color243
keyword whole FALSE color243
keyword whole ALL color243
keyword whole NONE color243
keyword whole AND color243
keyword whole OR color243
keyword whole NOT color243
keyword whole ! color17
keyword whole LIKE color243
keyword whole ANY color243
keyword whole IF color243
keyword whole EXISTS color243
keyword whole ASC color243
keyword whole DESC color243
keyword whole NULLS color243
keyword whole LAST color243
keyword whole ORDER color243
keyword whole GROUP color243
keyword whole BY color243
keyword whole HAVING color243
keyword whole WHERE color243
keyword whole FROM color243
keyword whole AS color243
keyword whole SELECT color243
keyword whole DISTINCT color243
keyword whole INSERT color243
keyword whole OVERWRITE color91
keyword whole OUTER color243
keyword whole UNIQUEJOIN color243
keyword whole PRESERVE color243
keyword whole JOIN color243
keyword whole LEFT color243
keyword whole RIGHT color243
keyword whole FULL color243
keyword whole ON color243
keyword whole PARTITION color243
keyword whole PARTITIONS color243
keyword whole TABLE color243
keyword whole TABLES color243
keyword whole COLUMNS color243
keyword whole INDEX color243
keyword whole INDEXES color243
keyword whole REBUILD color243
keyword whole FUNCTIONS color243
keyword whole SHOW color243
keyword whole MSCK color243
keyword whole REPAIR color243
keyword whole DIRECTORY color91
keyword whole LOCAL color91
keyword whole TRANSFORM color243
keyword whole USING color243
keyword whole CLUSTER color243
keyword whole DISTRIBUTE color243
keyword whole SORT color243
keyword whole UNION color243
keyword whole EXCEPT color243
keyword whole LOAD color243
keyword whole EXPORT color243
keyword whole IMPORT color243
keyword whole REPLICATION color243
keyword whole METADATA color243
keyword whole DATA color243
keyword whole INPATH color243
keyword whole IS color243
keyword whole NULL color243
keyword whole CREATE color243
keyword whole EXTERNAL color243
keyword whole ALTER color243
keyword whole CHANGE color243
keyword whole COLUMN color243
keyword whole FIRST color243
keyword whole AFTER color243
keyword whole DESCRIBE color91
keyword whole DROP color243
keyword whole RENAME color243
keyword whole TO color243
keyword whole COMMENT color243
keyword whole BOOLEAN color243
keyword whole TINYINT color243
keyword whole SMALLINT color243
keyword whole INT color243
keyword whole INTEGER color243
keyword whole BIGINT color243
keyword whole FLOAT color243
keyword whole DOUBLE color243
keyword whole PRECISION color243
keyword whole DATE color243
keyword whole DATETIME color243
keyword whole TIMESTAMP color243
keyword whole TIMESTAMPTZ color243
keyword whole TIME color243
keyword whole ZONE color243
keyword whole INTERVAL color243
keyword whole DECIMAL color243
keyword whole DEC color243
keyword whole NUMERIC color243
keyword whole STRING color243
keyword whole CHAR color243
keyword whole VARCHAR color243
keyword whole ARRAY color243
keyword whole STRUCT color243
keyword whole MAP color243
keyword whole UNIONTYPE color243
keyword whole REDUCE color243
keyword whole PARTITIONED color243
keyword whole CLUSTERED color243
keyword whole SORTED color243
keyword whole INTO color243
keyword whole BUCKETS color243
keyword whole ROW color91
keyword whole ROWS color91
keyword whole FORMAT color91
keyword whole DELIMITED color91
keyword whole FIELDS color91
keyword whole TERMINATED color91
keyword whole ESCAPED color91
keyword whole COLLECTION color243
keyword whole ITEMS color243
keyword whole KEYS color243
keyword whole $KEY$ color243
keyword whole LINES color91
keyword whole STORED color91
keyword whole FILEFORMAT color91
keyword whole INPUTFORMAT color91
keyword whole OUTPUTFORMAT color91
keyword whole INPUTDRIVER color243
keyword whole OUTPUTDRIVER color243
keyword whole ENABLE color243
keyword whole DISABLE color243
keyword whole LOCATION color91
keyword whole TABLESAMPLE color243
keyword whole BUCKET color243
keyword whole OUT color243
keyword whole OF color243
keyword whole PERCENT color243
keyword whole CAST color26
keyword whole ADD color243
keyword whole REPLACE color243
keyword whole RLIKE color243
keyword whole REGEXP color243
keyword whole TEMPORARY color243
keyword whole FUNCTION color243
keyword whole MACRO color243
keyword whole FILE color243
keyword whole JAR color243
keyword whole EXPLAIN color243
keyword whole EXTENDED color243
keyword whole FORMATTED color243
keyword whole PRETTY color243
keyword whole DEPENDENCY color243
keyword whole LOGICAL color243
keyword whole SERDE color243
keyword whole WITH color243
keyword whole DEFERRED color243
keyword whole SERDEPROPERTIES color243
keyword whole DBPROPERTIES color243
keyword whole LIMIT color243
keyword whole OFFSET color243
keyword whole SET color243
keyword whole UNSET color243
keyword whole TBLPROPERTIES color243
keyword whole IDXPROPERTIES color243
keyword whole $VALUE$ color243
keyword whole $ELEM$ color243
keyword whole DEFINED color243
keyword whole CASE color243
keyword whole WHEN color243
keyword whole THEN color243
keyword whole ELSE color243
keyword whole END color243
keyword whole MAPJOIN color243
keyword whole STREAMTABLE color243
keyword whole CLUSTERSTATUS color243
keyword whole UTC color243
keyword whole UTC_TMESTAMP color243
keyword whole LONG color243
keyword whole DELETE color243
keyword whole PLUS color243
keyword whole MINUS color243
keyword whole FETCH color243
keyword whole INTERSECT color243
keyword whole VIEW color243
keyword whole VIEWS color243
keyword whole IN color243
keyword whole DATABASE color243
keyword whole DATABASES color243
keyword whole MATERIALIZED color243
keyword whole SCHEMA color243
keyword whole SCHEMAS color243
keyword whole GRANT color243
keyword whole REVOKE color243
keyword whole SSL color243
keyword whole UNDO color243
keyword whole LOCK color243
keyword whole LOCKS color243
keyword whole UNLOCK color243
keyword whole SHARED color243
keyword whole EXCLUSIVE color243
keyword whole PROCEDURE color243
keyword whole UNSIGNED color243
keyword whole WHILE color243
keyword whole READ color243
keyword whole READS color243
keyword whole PURGE color243
keyword whole RANGE color243
keyword whole ANALYZE color243
keyword whole BEFORE color243
keyword whole BETWEEN color243
keyword whole BOTH color243
keyword whole BINARY color243
keyword whole CROSS color243
keyword whole CONTINUE color243
keyword whole CURSOR color243
keyword whole TRIGGER color243
keyword whole RECORDREADER color243
keyword whole RECORDWRITER color243
keyword whole SEMI color243
keyword whole LATERAL color91
keyword whole TOUCH color243
keyword whole ARCHIVE color91
keyword whole UNARCHIVE color91
keyword whole COMPUTE color243
keyword whole STATISTICS color243
keyword whole USE color91
keyword whole OPTION color243
keyword whole CONCATENATE color91
keyword whole SHOW_DATABASE color243
keyword whole UPDATE color243
keyword whole RESTRICT color243
keyword whole CASCADE color243
keyword whole SKEWED color243
keyword whole ROLLUP color243
keyword whole CUBE color243
keyword whole DIRECTORIES color243
keyword whole FOR color243
keyword whole WINDOW color243
keyword whole UNBOUNDED color243
keyword whole PRECEDING color243
keyword whole FOLLOWING color243
keyword whole CURRENT color243
keyword whole CURRENT_DATE color243
keyword whole CURRENT_TIMESTAMP color243
keyword whole LESS color243
keyword whole MORE color243
keyword whole OVER color243
keyword whole GROUPING color243
keyword whole SETS color243
keyword whole TRUNCATE color243
keyword whole NOSCAN color243
keyword whole PARTIALSCAN color243
keyword whole USER color243
keyword whole ROLE color243
keyword whole ROLES color243
keyword whole INNER color243
keyword whole EXCHANGE color243
keyword whole URI color243
keyword whole SERVER color243
keyword whole ADMIN color243
keyword whole OWNER color243
keyword whole PRINCIPALS color243
keyword whole COMPACT color243
keyword whole COMPACTIONS color243
keyword whole TRANSACTIONS color243
keyword whole REWRITE color243
keyword whole AUTHORIZATION color243
keyword whole CONF color243
keyword whole VALUES color243
keyword whole RELOAD color243
keyword whole YEAR color243
keyword whole YEARS color243
keyword whole QUARTER color243
keyword whole MONTH color243
keyword whole MONTHS color243
keyword whole WEEK color243
keyword whole WEEKS color243
keyword whole DAY color243
keyword whole DAYS color243
keyword whole DAYOFWEEK color243
keyword whole HOUR color243
keyword whole HOURS color243
keyword whole MINUTE color243
keyword whole MINUTES color243
keyword whole SECOND color243
keyword whole SECONDS color243
keyword whole START color243
keyword whole TRANSACTION color243
keyword whole COMMIT color243
keyword whole ROLLBACK color243
keyword whole WORK color243
keyword whole ONLY color243
keyword whole WRITE color243
keyword whole ISOLATION color243
keyword whole LEVEL color243
keyword whole SNAPSHOT color243
keyword whole AUTOCOMMIT color243
keyword whole CACHE color243
keyword whole PRIMARY color243
keyword whole FOREIGN color243
keyword whole REFERENCES color243
keyword whole CONSTRAINT color243
keyword whole VALIDATE color243
keyword whole NOVALIDATE color243
keyword whole RELY color243
keyword whole NORELY color243
keyword whole UNIQUE color243
keyword whole KEY color243
keyword whole ABORT color243
keyword whole EXTRACT color243
keyword whole FLOOR color243
keyword whole MERGE color243
keyword whole MATCHED color243
keyword whole REPL color243
keyword whole DUMP color243
keyword whole STATUS color243
keyword whole VECTORIZATION color243
keyword whole SUMMARY color243
keyword whole OPERATOR color243
keyword whole EXPRESSION color243
keyword whole DETAIL color243
keyword whole WAIT color243
# Storage Formats
keyword whole TEXTFILE color63
keyword whole ORC color63
keyword whole SEQUENCEFILE color63
keyword whole RCFILE color63
keyword whole PARQUET color63
keyword whole AVRO color63
# Comments
keyword /\* color30
keyword \*/ color30
keyword -- color30
# Operators
keyword > color17
keyword < color17
keyword \+ color17
keyword - color17
keyword \* color17
keyword / color17
keyword % color17
keyword = color17
keyword ( color17
keyword ) color17
keyword , color17
keyword ; color17
keyword . color243
keyword \| color243
keyword != color243
keyword \^ color243
keyword \~ color243
keyword whole DIV color243
keyword [ color17
keyword ] color17
keyword { color17
keyword } color17
keyword : color243
keyword & color243
keyword ? color243
# Mathematical Functions
keyword whole round color19
keyword whole bround color19
keyword whole floor color19
keyword whole ceil color19
keyword whole rand color19
keyword whole exp color19
keyword whole ln color19
keyword whole log10 color19
keyword whole log2 color19
keyword whole log color19
keyword whole pow color19
keyword whole sqrt color19
keyword whole bin color19
keyword whole hex color19
keyword whole unhex color19
keyword whole conv color19
keyword whole abs color19
keyword whole pmod color19
keyword whole sin color19
keyword whole asin color19
keyword whole cos color19
keyword whole acos color19
keyword whole tan color19
keyword whole atan color19
keyword whole degrees color19
keyword whole radians color19
keyword whole positive color19
keyword whole negative color19
keyword whole sign color19
keyword whole e() color19
keyword whole pi() color19
keyword whole factorial color19
keyword whole cbrt color19
keyword whole shiftleft color19
keyword whole shiftright color19
keyword whole shiftrightunsigned color19
keyword whole greatest color19
keyword whole least color19
keyword whole width_bucket color19
# Collection Functions
keyword whole size color19
keyword whole map_keys color19
keyword whole map_values color19
keyword whole array_contains color19
keyword whole sort_array color19
# Type Conversion
# binary # keyword
# cast # keyword
# Date Functions
keyword whole from_unixtime color19
keyword whole unix_timestamp color19
keyword whole to_date color19
keyword whole year color19
keyword whole quarter color19
keyword whole month color19
keyword whole day color19
keyword whole hour color19
keyword whole minute color19
keyword whole second color19
keyword whole weekofyear color19
keyword whole extract color19
keyword whole datediff color19
keyword whole date_add color19
keyword whole date_sub color19
keyword whole from_utc_timestamp color19
keyword whole to_utc_timestamp color19
keyword whole current_date color19
keyword whole add_months color19
keyword whole last_day color19
keyword whole next_day color19
keyword whole trunc color19
keyword whole months_between color19
keyword whole date_format color19
# Conditional Functions
keyword whole if color19
keyword whole isnull color19
keyword whole isnotnull color19
keyword whole coalesce color19
keyword whole nullif color19
keyword whole assert_true color19
# String Functions
keyword whole ascii color19
keyword whole base64 color19
keyword whole character_length color19
keyword whole chr color19
keyword whole concat color19
keyword whole context_ngrams color19
keyword whole concat_ws color19
keyword whole decode color19
keyword whole elt color19
keyword whole encode color19
keyword whole field color19
keyword whole find_in_set color19
keyword whole format_number color19
keyword whole get_json_object color19
keyword whole in_file color19
keyword whole instr color19
keyword whole length color19
keyword whole locate color19
keyword whole lower color19
keyword whole lpad color19
keyword whole ltrim color19
keyword whole ngrams color19
keyword whole octet_length color19
keyword whole parse_url color19
keyword whole printf color19
keyword whole regexp_extract color19
keyword whole regexp_replace color19
keyword whole repeat color19
keyword whole replace color19
keyword whole reverse color19
keyword whole rpad color19
keyword whole rtrim color19
keyword whole sentences color19
keyword whole space color19
keyword whole split color19
keyword whole str_to_map color19
keyword whole substr color19
keyword whole substr_index color19
keyword whole translate color19
keyword whole trim color19
keyword whole unbase64 color19
keyword whole upper color19
keyword whole initcap color19
keyword whole levenshtein color19
keyword whole soundex color19
# Data Masking Functions
keyword whole mask color19
keyword whole mask_first_n color19
keyword whole mask_last_n color19
keyword whole mask_show_first_n color19
keyword whole mask_show_last_n color19
keyword whole mask_hash color19
# Misc. Functions
keyword whole java_method color19
keyword whole reflect color19
keyword whole hash color19
keyword whole current_user color19
keyword whole logged_user color19
keyword whole md5 color19
keyword whole sha1 color19
keyword whole sha color19
keyword whole crc32 color19
keyword whole sha2 color19
keyword whole aes_encrypt color19
keyword whole aes_decrypt color19
keyword whole version color19
# xpath
keyword whole xpath color19
keyword whole xpath_short color19
keyword whole xpath_int color19
keyword whole xpath_long color19
keyword whole xpath_float color19
keyword whole xpath_double color19
keyword whole xpath_number color19
keyword whole xpath_string color19
# Aggregate Functions
keyword whole count color19
keyword whole sum color19
keyword whole avg color19
keyword whole min color19
keyword whole max color19
keyword whole variance color19
keyword whole var_samp color19
keyword whole stddev_pop color19
keyword whole stddev_samp color19
keyword whole covar_pop color19
keyword whole covar_samp color19
keyword whole corr color19
keyword whole percentile color19
keyword whole regr_avgx color19
keyword whole regr_avgy color19
keyword whole regr_count color19
keyword whole regr_intercept color19
keyword whole regr_r2 color19
keyword whole regr_slope color19
keyword whole regr_sxx color19
keyword whole regr_sxy color19
keyword whole regr_syy color19
keyword whole histogram_numeric color19
keyword whole collect_set color19
keyword whole collect_list color19
keyword whole ntile color19
# Table-Generating Functions
keyword whole explode color19
keyword whole posexplode color19
keyword whole inline color19
keyword whole stack color19
keyword whole json_tuple color19
keyword whole parse_url color19
# Window Functions
keyword whole lead color19
keyword whole lag color19
keyword whole first_value color19
keyword whole last_value color19
keyword whole rank color19
keyword whole row_number color19
keyword whole dense_rank color19
keyword whole cume_dist color19
keyword whole percent_rank color19
keyword whole ntile color19
# Variables
# oozie variables
keyword whole ${+} color88
# hive variables
keyword whole ${hiveconf:+} color91
# Hive options
keyword wholeright hive.+.+.+ color160
keyword wholeright tez.+.+ color160
keyword wholeright mapreduce.+.+ color160
# Literals
# float
keyword whole \[0123456789\]\{.\}\[0123456789\] color90
# float e notation
keyword whole \[0123456789\]\[.\]\[0123456789\]\{e\}\[\+-\]\{0123456789\}\[0123456789\] color90
# tinyint
keyword whole \{0123456789\}\[0123456789\]Y color91
# smallint
keyword whole \{0123456789\}\[0123456789\]S color91
# bigint
keyword whole \{0123456789\}\[0123456789\]L color91
# int
keyword whole \{0123456789\}\[0123456789\] color90
# big decimal
keyword whole \{0123456789\}\[0123456789\]BD color91
context exclusive -- \n color30
spellcheck
context exclusive /\* \*/ color30
spellcheck
context ' ' color28
keyword \\' color88
# oozie variables
keyword whole ${+} color88
# hive variables
keyword whole ${hiveconf:+} color91
context " " color160
keyword \\" color196