mirror of https://github.com/MidnightCommander/mc
628 lines
37 KiB
YAML
628 lines
37 KiB
YAML
# 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
|