path: root/misc/syntax/hive.syntax

# HQL syntax highlighting
# by Michal Lorek <michal.lorek@gmail.com>

caseinsensitive

context default

# Keywords
    keyword whole TRUE                                     white
    keyword whole FALSE                                    white
    keyword whole ALL                                      white
    keyword whole NONE                                     white
    keyword whole AND                                      white
    keyword whole OR                                       white
    keyword whole NOT                                      white
    keyword whole !                                        brightcyan
    keyword whole LIKE                                     white
    keyword whole ANY                                      white
    keyword whole IF                                       white
    keyword whole EXISTS                                   white
    keyword whole ASC                                      white
    keyword whole DESC                                     white
    keyword whole NULLS                                    white
    keyword whole LAST                                     white
    keyword whole ORDER                                    white
    keyword whole GROUP                                    white
    keyword whole BY                                       white
    keyword whole HAVING                                   white
    keyword whole WHERE                                    white
    keyword whole FROM                                     white
    keyword whole AS                                       white
    keyword whole SELECT                                   white
    keyword whole DISTINCT                                 white
    keyword whole INSERT                                   white
    keyword whole OVERWRITE                                magenta
    keyword whole OUTER                                    white
    keyword whole UNIQUEJOIN                               white
    keyword whole PRESERVE                                 white
    keyword whole JOIN                                     white
    keyword whole LEFT                                     white
    keyword whole RIGHT                                    white
    keyword whole FULL                                     white
    keyword whole ON                                       white
    keyword whole PARTITION                                white
    keyword whole PARTITIONS                               white
    keyword whole TABLE                                    white
    keyword whole TABLES                                   white
    keyword whole COLUMNS                                  white
    keyword whole INDEX                                    white
    keyword whole INDEXES                                  white
    keyword whole REBUILD                                  white
    keyword whole FUNCTIONS                                white
    keyword whole SHOW                                     white
    keyword whole MSCK                                     white
    keyword whole REPAIR                                   white
    keyword whole DIRECTORY                                magenta
    keyword whole LOCAL                                    magenta
    keyword whole TRANSFORM                                white
    keyword whole USING                                    white
    keyword whole CLUSTER                                  white
    keyword whole DISTRIBUTE                               white
    keyword whole SORT                                     white
    keyword whole UNION                                    white
    keyword whole EXCEPT                                   white
    keyword whole LOAD                                     white
    keyword whole EXPORT                                   white
    keyword whole IMPORT                                   white
    keyword whole REPLICATION                              white
    keyword whole METADATA                                 white
    keyword whole DATA                                     white
    keyword whole INPATH                                   white
    keyword whole IS                                       white
    keyword whole NULL                                     white
    keyword whole CREATE                                   white
    keyword whole EXTERNAL                                 white
    keyword whole ALTER                                    white
    keyword whole CHANGE                                   white
    keyword whole COLUMN                                   white
    keyword whole FIRST                                    white
    keyword whole AFTER                                    white
    keyword whole DESCRIBE                                 magenta
    keyword whole DROP                                     white
    keyword whole RENAME                                   white
    keyword whole TO                                       white
    keyword whole COMMENT                                  white
    keyword whole BOOLEAN                                  white
    keyword whole TINYINT                                  white
    keyword whole SMALLINT                                 white
    keyword whole INT                                      white
    keyword whole INTEGER                                  white
    keyword whole BIGINT                                   white
    keyword whole FLOAT                                    white
    keyword whole DOUBLE                                   white
    keyword whole PRECISION                                white
    keyword whole DATE                                     white
    keyword whole DATETIME                                 white
    keyword whole TIMESTAMP                                white
    keyword whole TIMESTAMPTZ                              white
    keyword whole TIME                                     white
    keyword whole ZONE                                     white
    keyword whole INTERVAL                                 white
    keyword whole DECIMAL                                  white
    keyword whole DEC                                      white
    keyword whole NUMERIC                                  white
    keyword whole STRING                                   white
    keyword whole CHAR                                     white
    keyword whole VARCHAR                                  white
    keyword whole ARRAY                                    white
    keyword whole STRUCT                                   white
    keyword whole MAP                                      white
    keyword whole UNIONTYPE                                white
    keyword whole REDUCE                                   white
    keyword whole PARTITIONED                              white
    keyword whole CLUSTERED                                white
    keyword whole SORTED                                   white
    keyword whole INTO                                     white
    keyword whole BUCKETS                                  white
    keyword whole ROW                                      magenta
    keyword whole ROWS                                     magenta
    keyword whole FORMAT                                   magenta
    keyword whole DELIMITED                                magenta
    keyword whole FIELDS                                   magenta
    keyword whole TERMINATED                               magenta
    keyword whole ESCAPED                                  magenta
    keyword whole COLLECTION                               white
    keyword whole ITEMS                                    white
    keyword whole KEYS                                     white
    keyword whole $KEY$                                    white
    keyword whole LINES                                    magenta
    keyword whole STORED                                   magenta
    keyword whole FILEFORMAT                               magenta
    keyword whole INPUTFORMAT                              magenta
    keyword whole OUTPUTFORMAT                             magenta
    keyword whole INPUTDRIVER                              white
    keyword whole OUTPUTDRIVER                             white
    keyword whole ENABLE                                   white
    keyword whole DISABLE                                  white
    keyword whole LOCATION                                 magenta
    keyword whole TABLESAMPLE                              white
    keyword whole BUCKET                                   white
    keyword whole OUT                                      white
    keyword whole OF                                       white
    keyword whole PERCENT                                  white
    keyword whole CAST                                     cyan
    keyword whole ADD                                      white
    keyword whole REPLACE                                  white
    keyword whole RLIKE                                    white
    keyword whole REGEXP                                   white
    keyword whole TEMPORARY                                white
    keyword whole FUNCTION                                 white
    keyword whole MACRO                                    white
    keyword whole FILE                                     white
    keyword whole JAR                                      white
    keyword whole EXPLAIN                                  white
    keyword whole EXTENDED                                 white
    keyword whole FORMATTED                                white
    keyword whole PRETTY                                   white
    keyword whole DEPENDENCY                               white
    keyword whole LOGICAL                                  white
    keyword whole SERDE                                    white
    keyword whole WITH                                     white
    keyword whole DEFERRED                                 white
    keyword whole SERDEPROPERTIES                          white
    keyword whole DBPROPERTIES                             white
    keyword whole LIMIT                                    white
    keyword whole OFFSET                                   white
    keyword whole SET                                      white
    keyword whole UNSET                                    white
    keyword whole TBLPROPERTIES                            white
    keyword whole IDXPROPERTIES                            white
    keyword whole $VALUE$                                  white
    keyword whole $ELEM$                                   white
    keyword whole DEFINED                                  white
    keyword whole CASE                                     white
    keyword whole WHEN                                     white
    keyword whole THEN                                     white
    keyword whole ELSE                                     white
    keyword whole END                                      white
    keyword whole MAPJOIN                                  white
    keyword whole STREAMTABLE                              white
    keyword whole CLUSTERSTATUS                            white
    keyword whole UTC                                      white
    keyword whole UTC_TMESTAMP                             white
    keyword whole LONG                                     white
    keyword whole DELETE                                   white
    keyword whole PLUS                                     white
    keyword whole MINUS                                    white
    keyword whole FETCH                                    white
    keyword whole INTERSECT                                white
    keyword whole VIEW                                     white
    keyword whole VIEWS                                    white
    keyword whole IN                                       white
    keyword whole DATABASE                                 white
    keyword whole DATABASES                                white
    keyword whole MATERIALIZED                             white
    keyword whole SCHEMA                                   white
    keyword whole SCHEMAS                                  white
    keyword whole GRANT                                    white
    keyword whole REVOKE                                   white
    keyword whole SSL                                      white
    keyword whole UNDO                                     white
    keyword whole LOCK                                     white
    keyword whole LOCKS                                    white
    keyword whole UNLOCK                                   white
    keyword whole SHARED                                   white
    keyword whole EXCLUSIVE                                white
    keyword whole PROCEDURE                                white
    keyword whole UNSIGNED                                 white
    keyword whole WHILE                                    white
    keyword whole READ                                     white
    keyword whole READS                                    white
    keyword whole PURGE                                    white
    keyword whole RANGE                                    white
    keyword whole ANALYZE                                  white
    keyword whole BEFORE                                   white
    keyword whole BETWEEN                                  white
    keyword whole BOTH                                     white
    keyword whole BINARY                                   white
    keyword whole CROSS                                    white
    keyword whole CONTINUE                                 white
    keyword whole CURSOR                                   white
    keyword whole TRIGGER                                  white
    keyword whole RECORDREADER                             white
    keyword whole RECORDWRITER                             white
    keyword whole SEMI                                     white
    keyword whole LATERAL                                  magenta
    keyword whole TOUCH                                    white
    keyword whole ARCHIVE                                  magenta
    keyword whole UNARCHIVE                                magenta
    keyword whole COMPUTE                                  white
    keyword whole STATISTICS                               white
    keyword whole USE                                      magenta
    keyword whole OPTION                                   white
    keyword whole CONCATENATE                              magenta
    keyword whole SHOW_DATABASE                            white
    keyword whole UPDATE                                   white
    keyword whole RESTRICT                                 white
    keyword whole CASCADE                                  white
    keyword whole SKEWED                                   white
    keyword whole ROLLUP                                   white
    keyword whole CUBE                                     white
    keyword whole DIRECTORIES                              white
    keyword whole FOR                                      white
    keyword whole WINDOW                                   white
    keyword whole UNBOUNDED                                white
    keyword whole PRECEDING                                white
    keyword whole FOLLOWING                                white
    keyword whole CURRENT                                  white
    keyword whole CURRENT_DATE                             white
    keyword whole CURRENT_TIMESTAMP                        white
    keyword whole LESS                                     white
    keyword whole MORE                                     white
    keyword whole OVER                                     white
    keyword whole GROUPING                                 white
    keyword whole SETS                                     white
    keyword whole TRUNCATE                                 white
    keyword whole NOSCAN                                   white
    keyword whole PARTIALSCAN                              white
    keyword whole USER                                     white
    keyword whole ROLE                                     white
    keyword whole ROLES                                    white
    keyword whole INNER                                    white
    keyword whole EXCHANGE                                 white
    keyword whole URI                                      white
    keyword whole SERVER                                   white
    keyword whole ADMIN                                    white
    keyword whole OWNER                                    white
    keyword whole PRINCIPALS                               white
    keyword whole COMPACT                                  white
    keyword whole COMPACTIONS                              white
    keyword whole TRANSACTIONS                             white
    keyword whole REWRITE                                  white
    keyword whole AUTHORIZATION                            white
    keyword whole CONF                                     white
    keyword whole VALUES                                   white
    keyword whole RELOAD                                   white
    keyword whole YEAR                                     white
    keyword whole YEARS                                    white
    keyword whole QUARTER                                  white
    keyword whole MONTH                                    white
    keyword whole MONTHS                                   white
    keyword whole WEEK                                     white
    keyword whole WEEKS                                    white
    keyword whole DAY                                      white
    keyword whole DAYS                                     white
    keyword whole DAYOFWEEK                                white
    keyword whole HOUR                                     white
    keyword whole HOURS                                    white
    keyword whole MINUTE                                   white
    keyword whole MINUTES                                  white
    keyword whole SECOND                                   white
    keyword whole SECONDS                                  white
    keyword whole START                                    white
    keyword whole TRANSACTION                              white
    keyword whole COMMIT                                   white
    keyword whole ROLLBACK                                 white
    keyword whole WORK                                     white
    keyword whole ONLY                                     white
    keyword whole WRITE                                    white
    keyword whole ISOLATION                                white
    keyword whole LEVEL                                    white
    keyword whole SNAPSHOT                                 white
    keyword whole AUTOCOMMIT                               white
    keyword whole CACHE                                    white
    keyword whole PRIMARY                                  white
    keyword whole FOREIGN                                  white
    keyword whole REFERENCES                               white
    keyword whole CONSTRAINT                               white
    keyword whole VALIDATE                                 white
    keyword whole NOVALIDATE                               white
    keyword whole RELY                                     white
    keyword whole NORELY                                   white
    keyword whole UNIQUE                                   white
    keyword whole KEY                                      white
    keyword whole ABORT                                    white
    keyword whole EXTRACT                                  white
    keyword whole FLOOR                                    white
    keyword whole MERGE                                    white
    keyword whole MATCHED                                  white
    keyword whole REPL                                     white
    keyword whole DUMP                                     white
    keyword whole STATUS                                   white
    keyword whole VECTORIZATION                            white
    keyword whole SUMMARY                                  white
    keyword whole OPERATOR                                 white
    keyword whole EXPRESSION                               white
    keyword whole DETAIL                                   white
    keyword whole WAIT                                     white

# Storage Formats
    keyword whole TEXTFILE                                 brightblue
    keyword whole ORC                                      brightblue
    keyword whole SEQUENCEFILE                             brightblue
    keyword whole RCFILE                                   brightblue
    keyword whole PARQUET                                  brightblue
    keyword whole AVRO                                     brightblue

# Comments
    keyword /\*                                            brown
    keyword \*/                                            brown
    keyword --                                             brown

# Operators
    keyword >                                              brightcyan
    keyword <                                              brightcyan
    keyword \+                                             brightcyan
    keyword -                                              brightcyan
    keyword \*                                             brightcyan
    keyword /                                              brightcyan
    keyword %                                              brightcyan
    keyword =                                              brightcyan
    keyword (                                              brightcyan
    keyword )                                              brightcyan
    keyword ,                                              brightcyan
    keyword ;                                              brightcyan
    keyword .                                              white
    keyword \|                                             white
    keyword !=                                             white
    keyword \^                                             white
    keyword \~                                             white
    keyword whole DIV                                      white
    keyword [                                              brightcyan
    keyword ]                                              brightcyan
    keyword {                                              brightcyan
    keyword }                                              brightcyan
    keyword :                                              white
    keyword &                                              white
    keyword ?                                              white

# Mathematical Functions
    keyword whole round                                    yellow
    keyword whole bround                                   yellow
    keyword whole floor                                    yellow
    keyword whole ceil                                     yellow
    keyword whole rand                                     yellow
    keyword whole exp                                      yellow
    keyword whole ln                                       yellow
    keyword whole log10                                    yellow
    keyword whole log2                                     yellow
    keyword whole log                                      yellow
    keyword whole pow                                      yellow
    keyword whole sqrt                                     yellow
    keyword whole bin                                      yellow
    keyword whole hex                                      yellow
    keyword whole unhex                                    yellow
    keyword whole conv                                     yellow
    keyword whole abs                                      yellow
    keyword whole pmod                                     yellow
    keyword whole sin                                      yellow
    keyword whole asin                                     yellow
    keyword whole cos                                      yellow
    keyword whole acos                                     yellow
    keyword whole tan                                      yellow
    keyword whole atan                                     yellow
    keyword whole degrees                                  yellow
    keyword whole radians                                  yellow
    keyword whole positive                                 yellow
    keyword whole negative                                 yellow
    keyword whole sign                                     yellow
    keyword whole e()                                      yellow
    keyword whole pi()                                     yellow
    keyword whole factorial                                yellow
    keyword whole cbrt                                     yellow
    keyword whole shiftleft                                yellow
    keyword whole shiftright                               yellow
    keyword whole shiftrightunsigned                       yellow
    keyword whole greatest                                 yellow
    keyword whole least                                    yellow
    keyword whole width_bucket                             yellow

# Collection Functions
    keyword whole size                                     yellow
    keyword whole map_keys                                 yellow
    keyword whole map_values                               yellow
    keyword whole array_contains                           yellow
    keyword whole sort_array                               yellow

# Type Conversion
#   binary # keyword
#   cast   # keyword

# Date Functions
    keyword whole from_unixtime                            yellow
    keyword whole unix_timestamp                           yellow
    keyword whole to_date                                  yellow
    keyword whole year                                     yellow
    keyword whole quarter                                  yellow
    keyword whole month                                    yellow
    keyword whole day                                      yellow
    keyword whole hour                                     yellow
    keyword whole minute                                   yellow
    keyword whole second                                   yellow
    keyword whole weekofyear                               yellow
    keyword whole extract                                  yellow
    keyword whole datediff                                 yellow
    keyword whole date_add                                 yellow
    keyword whole date_sub                                 yellow
    keyword whole from_utc_timestamp                       yellow
    keyword whole to_utc_timestamp                         yellow
    keyword whole current_date                             yellow
    keyword whole add_months                               yellow
    keyword whole last_day                                 yellow
    keyword whole next_day                                 yellow
    keyword whole trunc                                    yellow
    keyword whole months_between                           yellow
    keyword whole date_format                              yellow

# Conditional Functions
    keyword whole if                                       yellow
    keyword whole isnull                                   yellow
    keyword whole isnotnull                                yellow
    keyword whole coalesce                                 yellow
    keyword whole nullif                                   yellow
    keyword whole assert_true                              yellow

# String Functions
    keyword whole ascii                                    yellow
    keyword whole base64                                   yellow
    keyword whole character_length                         yellow
    keyword whole chr                                      yellow
    keyword whole concat                                   yellow
    keyword whole context_ngrams                           yellow
    keyword whole concat_ws                                yellow
    keyword whole decode                                   yellow
    keyword whole elt                                      yellow
    keyword whole encode                                   yellow
    keyword whole field                                    yellow
    keyword whole find_in_set                              yellow
    keyword whole format_number                            yellow
    keyword whole get_json_object                          yellow
    keyword whole in_file                                  yellow
    keyword whole instr                                    yellow
    keyword whole length                                   yellow
    keyword whole locate                                   yellow
    keyword whole lower                                    yellow
    keyword whole lpad                                     yellow
    keyword whole ltrim                                    yellow
    keyword whole ngrams                                   yellow
    keyword whole octet_length                             yellow
    keyword whole parse_url                                yellow
    keyword whole printf                                   yellow
    keyword whole regexp_extract                           yellow
    keyword whole regexp_replace                           yellow
    keyword whole repeat                                   yellow
    keyword whole replace                                  yellow
    keyword whole reverse                                  yellow
    keyword whole rpad                                     yellow
    keyword whole rtrim                                    yellow
    keyword whole sentences                                yellow
    keyword whole space                                    yellow
    keyword whole split                                    yellow
    keyword whole str_to_map                               yellow
    keyword whole substr                                   yellow
    keyword whole substr_index                             yellow
    keyword whole translate                                yellow
    keyword whole trim                                     yellow
    keyword whole unbase64                                 yellow
    keyword whole upper                                    yellow
    keyword whole initcap                                  yellow
    keyword whole levenshtein                              yellow
    keyword whole soundex                                  yellow

# Data Masking Functions
    keyword whole mask                                     yellow
    keyword whole mask_first_n                             yellow
    keyword whole mask_last_n                              yellow
    keyword whole mask_show_first_n                        yellow
    keyword whole mask_show_last_n                         yellow
    keyword whole mask_hash                                yellow

# Misc. Functions
    keyword whole java_method                              yellow
    keyword whole reflect                                  yellow
    keyword whole hash                                     yellow
    keyword whole current_user                             yellow
    keyword whole logged_user                              yellow
    keyword whole md5                                      yellow
    keyword whole sha1                                     yellow
    keyword whole sha                                      yellow
    keyword whole crc32                                    yellow
    keyword whole sha2                                     yellow
    keyword whole aes_encrypt                              yellow
    keyword whole aes_decrypt                              yellow
    keyword whole version                                  yellow

# xpath
    keyword whole xpath                                    yellow
    keyword whole xpath_short                              yellow
    keyword whole xpath_int                                yellow
    keyword whole xpath_long                               yellow
    keyword whole xpath_float                              yellow
    keyword whole xpath_double                             yellow
    keyword whole xpath_number                             yellow
    keyword whole xpath_string                             yellow

# Aggregate Functions
    keyword whole count                                    yellow
    keyword whole sum                                      yellow
    keyword whole avg                                      yellow
    keyword whole min                                      yellow
    keyword whole max                                      yellow
    keyword whole variance                                 yellow
    keyword whole var_samp                                 yellow
    keyword whole stddev_pop                               yellow
    keyword whole stddev_samp                              yellow
    keyword whole covar_pop                                yellow
    keyword whole covar_samp                               yellow
    keyword whole corr                                     yellow
    keyword whole percentile                               yellow
    keyword whole regr_avgx                                yellow
    keyword whole regr_avgy                                yellow
    keyword whole regr_count                               yellow
    keyword whole regr_intercept                           yellow
    keyword whole regr_r2                                  yellow
    keyword whole regr_slope                               yellow
    keyword whole regr_sxx                                 yellow
    keyword whole regr_sxy                                 yellow
    keyword whole regr_syy                                 yellow
    keyword whole histogram_numeric                        yellow
    keyword whole collect_set                              yellow
    keyword whole collect_list                             yellow
    keyword whole ntile                                    yellow

# Table-Generating Functions
    keyword whole explode                                  yellow
    keyword whole posexplode                               yellow
    keyword whole inline                                   yellow
    keyword whole stack                                    yellow
    keyword whole json_tuple                               yellow
    keyword whole parse_url                                yellow

# Window Functions
    keyword whole lead                                     yellow
    keyword whole lag                                      yellow
    keyword whole first_value                              yellow
    keyword whole last_value                               yellow
    keyword whole rank                                     yellow
    keyword whole row_number                               yellow
    keyword whole dense_rank                               yellow
    keyword whole cume_dist                                yellow
    keyword whole percent_rank                             yellow
    keyword whole ntile                                    yellow

# Variables
    # oozie variables
    keyword whole ${+}                                     brightgreen
    # hive variables
    keyword whole ${hiveconf:+}                            magenta


# Hive options
    keyword wholeright hive.+.+.+                          red
    keyword wholeright tez.+.+                             red
    keyword wholeright mapreduce.+.+                       red

# Literals
    # float
    keyword whole \[0123456789\]\{.\}\[0123456789\]                                           brightmagenta
    # float e notation
    keyword whole \[0123456789\]\[.\]\[0123456789\]\{e\}\[\+-\]\{0123456789\}\[0123456789\]   brightmagenta

    # tinyint
    keyword whole \{0123456789\}\[0123456789\]Y                magenta
    # smallint
    keyword whole \{0123456789\}\[0123456789\]S                magenta
    # bigint
    keyword whole \{0123456789\}\[0123456789\]L                magenta
    # int
    keyword whole \{0123456789\}\[0123456789\]                 brightmagenta
    # big decimal
    keyword whole \{0123456789\}\[0123456789\]BD               magenta

context exclusive -- \n brown
    spellcheck

context exclusive /\* \*/ brown
    spellcheck

context ' ' green
    keyword \\' brightgreen
    # oozie variables
    keyword whole ${+}                                         brightgreen
    # hive variables
    keyword whole ${hiveconf:+}                                magenta

context " " red
    keyword \\" brightred