| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627 |
- # 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
|
