misc/syntax/hive.syntax

   1 # HQL syntax highlighting
   2 # by Michal Lorek <michal.lorek@gmail.com>
   3
   4 caseinsensitive
   5
   6 context default
   7
   8 # Keywords
   9     keyword whole TRUE                                     white
  10     keyword whole FALSE                                    white
  11     keyword whole ALL                                      white
  12     keyword whole NONE                                     white
  13     keyword whole AND                                      white
  14     keyword whole OR                                       white
  15     keyword whole NOT                                      white
  16     keyword whole !                                        brightcyan
  17     keyword whole LIKE                                     white
  18     keyword whole ANY                                      white
  19     keyword whole IF                                       white
  20     keyword whole EXISTS                                   white
  21     keyword whole ASC                                      white
  22     keyword whole DESC                                     white
  23     keyword whole NULLS                                    white
  24     keyword whole LAST                                     white
  25     keyword whole ORDER                                    white
  26     keyword whole GROUP                                    white
  27     keyword whole BY                                       white
  28     keyword whole HAVING                                   white
  29     keyword whole WHERE                                    white
  30     keyword whole FROM                                     white
  31     keyword whole AS                                       white
  32     keyword whole SELECT                                   white
  33     keyword whole DISTINCT                                 white
  34     keyword whole INSERT                                   white
  35     keyword whole OVERWRITE                                magenta
  36     keyword whole OUTER                                    white
  37     keyword whole UNIQUEJOIN                               white
  38     keyword whole PRESERVE                                 white
  39     keyword whole JOIN                                     white
  40     keyword whole LEFT                                     white
  41     keyword whole RIGHT                                    white
  42     keyword whole FULL                                     white
  43     keyword whole ON                                       white
  44     keyword whole PARTITION                                white
  45     keyword whole PARTITIONS                               white
  46     keyword whole TABLE                                    white
  47     keyword whole TABLES                                   white
  48     keyword whole COLUMNS                                  white
  49     keyword whole INDEX                                    white
  50     keyword whole INDEXES                                  white
  51     keyword whole REBUILD                                  white
  52     keyword whole FUNCTIONS                                white
  53     keyword whole SHOW                                     white
  54     keyword whole MSCK                                     white
  55     keyword whole REPAIR                                   white
  56     keyword whole DIRECTORY                                magenta
  57     keyword whole LOCAL                                    magenta
  58     keyword whole TRANSFORM                                white
  59     keyword whole USING                                    white
  60     keyword whole CLUSTER                                  white
  61     keyword whole DISTRIBUTE                               white
  62     keyword whole SORT                                     white
  63     keyword whole UNION                                    white
  64     keyword whole EXCEPT                                   white
  65     keyword whole LOAD                                     white
  66     keyword whole EXPORT                                   white
  67     keyword whole IMPORT                                   white
  68     keyword whole REPLICATION                              white
  69     keyword whole METADATA                                 white
  70     keyword whole DATA                                     white
  71     keyword whole INPATH                                   white
  72     keyword whole IS                                       white
  73     keyword whole NULL                                     white
  74     keyword whole CREATE                                   white
  75     keyword whole EXTERNAL                                 white
  76     keyword whole ALTER                                    white
  77     keyword whole CHANGE                                   white
  78     keyword whole COLUMN                                   white
  79     keyword whole FIRST                                    white
  80     keyword whole AFTER                                    white
  81     keyword whole DESCRIBE                                 magenta
  82     keyword whole DROP                                     white
  83     keyword whole RENAME                                   white
  84     keyword whole TO                                       white
  85     keyword whole COMMENT                                  white
  86     keyword whole BOOLEAN                                  white
  87     keyword whole TINYINT                                  white
  88     keyword whole SMALLINT                                 white
  89     keyword whole INT                                      white
  90     keyword whole INTEGER                                  white
  91     keyword whole BIGINT                                   white
  92     keyword whole FLOAT                                    white
  93     keyword whole DOUBLE                                   white
  94     keyword whole PRECISION                                white
  95     keyword whole DATE                                     white
  96     keyword whole DATETIME                                 white
  97     keyword whole TIMESTAMP                                white
  98     keyword whole TIMESTAMPTZ                              white
  99     keyword whole TIME                                     white
 100     keyword whole ZONE                                     white
 101     keyword whole INTERVAL                                 white
 102     keyword whole DECIMAL                                  white
 103     keyword whole DEC                                      white
 104     keyword whole NUMERIC                                  white
 105     keyword whole STRING                                   white
 106     keyword whole CHAR                                     white
 107     keyword whole VARCHAR                                  white
 108     keyword whole ARRAY                                    white
 109     keyword whole STRUCT                                   white
 110     keyword whole MAP                                      white
 111     keyword whole UNIONTYPE                                white
 112     keyword whole REDUCE                                   white
 113     keyword whole PARTITIONED                              white
 114     keyword whole CLUSTERED                                white
 115     keyword whole SORTED                                   white
 116     keyword whole INTO                                     white
 117     keyword whole BUCKETS                                  white
 118     keyword whole ROW                                      magenta
 119     keyword whole ROWS                                     magenta
 120     keyword whole FORMAT                                   magenta
 121     keyword whole DELIMITED                                magenta
 122     keyword whole FIELDS                                   magenta
 123     keyword whole TERMINATED                               magenta
 124     keyword whole ESCAPED                                  magenta
 125     keyword whole COLLECTION                               white
 126     keyword whole ITEMS                                    white
 127     keyword whole KEYS                                     white
 128     keyword whole $KEY$                                    white
 129     keyword whole LINES                                    magenta
 130     keyword whole STORED                                   magenta
 131     keyword whole FILEFORMAT                               magenta
 132     keyword whole INPUTFORMAT                              magenta
 133     keyword whole OUTPUTFORMAT                             magenta
 134     keyword whole INPUTDRIVER                              white
 135     keyword whole OUTPUTDRIVER                             white
 136     keyword whole ENABLE                                   white
 137     keyword whole DISABLE                                  white
 138     keyword whole LOCATION                                 magenta
 139     keyword whole TABLESAMPLE                              white
 140     keyword whole BUCKET                                   white
 141     keyword whole OUT                                      white
 142     keyword whole OF                                       white
 143     keyword whole PERCENT                                  white
 144     keyword whole CAST                                     cyan
 145     keyword whole ADD                                      white
 146     keyword whole REPLACE                                  white
 147     keyword whole RLIKE                                    white
 148     keyword whole REGEXP                                   white
 149     keyword whole TEMPORARY                                white
 150     keyword whole FUNCTION                                 white
 151     keyword whole MACRO                                    white
 152     keyword whole FILE                                     white
 153     keyword whole JAR                                      white
 154     keyword whole EXPLAIN                                  white
 155     keyword whole EXTENDED                                 white
 156     keyword whole FORMATTED                                white
 157     keyword whole PRETTY                                   white
 158     keyword whole DEPENDENCY                               white
 159     keyword whole LOGICAL                                  white
 160     keyword whole SERDE                                    white
 161     keyword whole WITH                                     white
 162     keyword whole DEFERRED                                 white
 163     keyword whole SERDEPROPERTIES                          white
 164     keyword whole DBPROPERTIES                             white
 165     keyword whole LIMIT                                    white
 166     keyword whole OFFSET                                   white
 167     keyword whole SET                                      white
 168     keyword whole UNSET                                    white
 169     keyword whole TBLPROPERTIES                            white
 170     keyword whole IDXPROPERTIES                            white
 171     keyword whole $VALUE$                                  white
 172     keyword whole $ELEM$                                   white
 173     keyword whole DEFINED                                  white
 174     keyword whole CASE                                     white
 175     keyword whole WHEN                                     white
 176     keyword whole THEN                                     white
 177     keyword whole ELSE                                     white
 178     keyword whole END                                      white
 179     keyword whole MAPJOIN                                  white
 180     keyword whole STREAMTABLE                              white
 181     keyword whole CLUSTERSTATUS                            white
 182     keyword whole UTC                                      white
 183     keyword whole UTC_TMESTAMP                             white
 184     keyword whole LONG                                     white
 185     keyword whole DELETE                                   white
 186     keyword whole PLUS                                     white
 187     keyword whole MINUS                                    white
 188     keyword whole FETCH                                    white
 189     keyword whole INTERSECT                                white
 190     keyword whole VIEW                                     white
 191     keyword whole VIEWS                                    white
 192     keyword whole IN                                       white
 193     keyword whole DATABASE                                 white
 194     keyword whole DATABASES                                white
 195     keyword whole MATERIALIZED                             white
 196     keyword whole SCHEMA                                   white
 197     keyword whole SCHEMAS                                  white
 198     keyword whole GRANT                                    white
 199     keyword whole REVOKE                                   white
 200     keyword whole SSL                                      white
 201     keyword whole UNDO                                     white
 202     keyword whole LOCK                                     white
 203     keyword whole LOCKS                                    white
 204     keyword whole UNLOCK                                   white
 205     keyword whole SHARED                                   white
 206     keyword whole EXCLUSIVE                                white
 207     keyword whole PROCEDURE                                white
 208     keyword whole UNSIGNED                                 white
 209     keyword whole WHILE                                    white
 210     keyword whole READ                                     white
 211     keyword whole READS                                    white
 212     keyword whole PURGE                                    white
 213     keyword whole RANGE                                    white
 214     keyword whole ANALYZE                                  white
 215     keyword whole BEFORE                                   white
 216     keyword whole BETWEEN                                  white
 217     keyword whole BOTH                                     white
 218     keyword whole BINARY                                   white
 219     keyword whole CROSS                                    white
 220     keyword whole CONTINUE                                 white
 221     keyword whole CURSOR                                   white
 222     keyword whole TRIGGER                                  white
 223     keyword whole RECORDREADER                             white
 224     keyword whole RECORDWRITER                             white
 225     keyword whole SEMI                                     white
 226     keyword whole LATERAL                                  magenta
 227     keyword whole TOUCH                                    white
 228     keyword whole ARCHIVE                                  magenta
 229     keyword whole UNARCHIVE                                magenta
 230     keyword whole COMPUTE                                  white
 231     keyword whole STATISTICS                               white
 232     keyword whole USE                                      magenta
 233     keyword whole OPTION                                   white
 234     keyword whole CONCATENATE                              magenta
 235     keyword whole SHOW_DATABASE                            white
 236     keyword whole UPDATE                                   white
 237     keyword whole RESTRICT                                 white
 238     keyword whole CASCADE                                  white
 239     keyword whole SKEWED                                   white
 240     keyword whole ROLLUP                                   white
 241     keyword whole CUBE                                     white
 242     keyword whole DIRECTORIES                              white
 243     keyword whole FOR                                      white
 244     keyword whole WINDOW                                   white
 245     keyword whole UNBOUNDED                                white
 246     keyword whole PRECEDING                                white
 247     keyword whole FOLLOWING                                white
 248     keyword whole CURRENT                                  white
 249     keyword whole CURRENT_DATE                             white
 250     keyword whole CURRENT_TIMESTAMP                        white
 251     keyword whole LESS                                     white
 252     keyword whole MORE                                     white
 253     keyword whole OVER                                     white
 254     keyword whole GROUPING                                 white
 255     keyword whole SETS                                     white
 256     keyword whole TRUNCATE                                 white
 257     keyword whole NOSCAN                                   white
 258     keyword whole PARTIALSCAN                              white
 259     keyword whole USER                                     white
 260     keyword whole ROLE                                     white
 261     keyword whole ROLES                                    white
 262     keyword whole INNER                                    white
 263     keyword whole EXCHANGE                                 white
 264     keyword whole URI                                      white
 265     keyword whole SERVER                                   white
 266     keyword whole ADMIN                                    white
 267     keyword whole OWNER                                    white
 268     keyword whole PRINCIPALS                               white
 269     keyword whole COMPACT                                  white
 270     keyword whole COMPACTIONS                              white
 271     keyword whole TRANSACTIONS                             white
 272     keyword whole REWRITE                                  white
 273     keyword whole AUTHORIZATION                            white
 274     keyword whole CONF                                     white
 275     keyword whole VALUES                                   white
 276     keyword whole RELOAD                                   white
 277     keyword whole YEAR                                     white
 278     keyword whole YEARS                                    white
 279     keyword whole QUARTER                                  white
 280     keyword whole MONTH                                    white
 281     keyword whole MONTHS                                   white
 282     keyword whole WEEK                                     white
 283     keyword whole WEEKS                                    white
 284     keyword whole DAY                                      white
 285     keyword whole DAYS                                     white
 286     keyword whole DAYOFWEEK                                white
 287     keyword whole HOUR                                     white
 288     keyword whole HOURS                                    white
 289     keyword whole MINUTE                                   white
 290     keyword whole MINUTES                                  white
 291     keyword whole SECOND                                   white
 292     keyword whole SECONDS                                  white
 293     keyword whole START                                    white
 294     keyword whole TRANSACTION                              white
 295     keyword whole COMMIT                                   white
 296     keyword whole ROLLBACK                                 white
 297     keyword whole WORK                                     white
 298     keyword whole ONLY                                     white
 299     keyword whole WRITE                                    white
 300     keyword whole ISOLATION                                white
 301     keyword whole LEVEL                                    white
 302     keyword whole SNAPSHOT                                 white
 303     keyword whole AUTOCOMMIT                               white
 304     keyword whole CACHE                                    white
 305     keyword whole PRIMARY                                  white
 306     keyword whole FOREIGN                                  white
 307     keyword whole REFERENCES                               white
 308     keyword whole CONSTRAINT                               white
 309     keyword whole VALIDATE                                 white
 310     keyword whole NOVALIDATE                               white
 311     keyword whole RELY                                     white
 312     keyword whole NORELY                                   white
 313     keyword whole UNIQUE                                   white
 314     keyword whole KEY                                      white
 315     keyword whole ABORT                                    white
 316     keyword whole EXTRACT                                  white
 317     keyword whole FLOOR                                    white
 318     keyword whole MERGE                                    white
 319     keyword whole MATCHED                                  white
 320     keyword whole REPL                                     white
 321     keyword whole DUMP                                     white
 322     keyword whole STATUS                                   white
 323     keyword whole VECTORIZATION                            white
 324     keyword whole SUMMARY                                  white
 325     keyword whole OPERATOR                                 white
 326     keyword whole EXPRESSION                               white
 327     keyword whole DETAIL                                   white
 328     keyword whole WAIT                                     white
 329
 330 # Storage Formats
 331     keyword whole TEXTFILE                                 brightblue
 332     keyword whole ORC                                      brightblue
 333     keyword whole SEQUENCEFILE                             brightblue
 334     keyword whole RCFILE                                   brightblue
 335     keyword whole PARQUET                                  brightblue
 336     keyword whole AVRO                                     brightblue
 337
 338 # Comments
 339     keyword /\*                                            brown
 340     keyword \*/                                            brown
 341     keyword --                                             brown
 342
 343 # Operators
 344     keyword >                                              brightcyan
 345     keyword <                                              brightcyan
 346     keyword \+                                             brightcyan
 347     keyword -                                              brightcyan
 348     keyword \*                                             brightcyan
 349     keyword /                                              brightcyan
 350     keyword %                                              brightcyan
 351     keyword =                                              brightcyan
 352     keyword (                                              brightcyan
 353     keyword )                                              brightcyan
 354     keyword ,                                              brightcyan
 355     keyword ;                                              brightcyan
 356     keyword .                                              white
 357     keyword \|                                             white
 358     keyword !=                                             white
 359     keyword \^                                             white
 360     keyword \~                                             white
 361     keyword whole DIV                                      white
 362     keyword [                                              brightcyan
 363     keyword ]                                              brightcyan
 364     keyword {                                              brightcyan
 365     keyword }                                              brightcyan
 366     keyword :                                              white
 367     keyword &                                              white
 368     keyword ?                                              white
 369
 370 # Mathematical Functions
 371     keyword whole round                                    yellow
 372     keyword whole bround                                   yellow
 373     keyword whole floor                                    yellow
 374     keyword whole ceil                                     yellow
 375     keyword whole rand                                     yellow
 376     keyword whole exp                                      yellow
 377     keyword whole ln                                       yellow
 378     keyword whole log10                                    yellow
 379     keyword whole log2                                     yellow
 380     keyword whole log                                      yellow
 381     keyword whole pow                                      yellow
 382     keyword whole sqrt                                     yellow
 383     keyword whole bin                                      yellow
 384     keyword whole hex                                      yellow
 385     keyword whole unhex                                    yellow
 386     keyword whole conv                                     yellow
 387     keyword whole abs                                      yellow
 388     keyword whole pmod                                     yellow
 389     keyword whole sin                                      yellow
 390     keyword whole asin                                     yellow
 391     keyword whole cos                                      yellow
 392     keyword whole acos                                     yellow
 393     keyword whole tan                                      yellow
 394     keyword whole atan                                     yellow
 395     keyword whole degrees                                  yellow
 396     keyword whole radians                                  yellow
 397     keyword whole positive                                 yellow
 398     keyword whole negative                                 yellow
 399     keyword whole sign                                     yellow
 400     keyword whole e()                                      yellow
 401     keyword whole pi()                                     yellow
 402     keyword whole factorial                                yellow
 403     keyword whole cbrt                                     yellow
 404     keyword whole shiftleft                                yellow
 405     keyword whole shiftright                               yellow
 406     keyword whole shiftrightunsigned                       yellow
 407     keyword whole greatest                                 yellow
 408     keyword whole least                                    yellow
 409     keyword whole width_bucket                             yellow
 410
 411 # Collection Functions
 412     keyword whole size                                     yellow
 413     keyword whole map_keys                                 yellow
 414     keyword whole map_values                               yellow
 415     keyword whole array_contains                           yellow
 416     keyword whole sort_array                               yellow
 417
 418 # Type Conversion
 419 #   binary # keyword
 420 #   cast   # keyword
 421
 422 # Date Functions
 423     keyword whole from_unixtime                            yellow
 424     keyword whole unix_timestamp                           yellow
 425     keyword whole to_date                                  yellow
 426     keyword whole year                                     yellow
 427     keyword whole quarter                                  yellow
 428     keyword whole month                                    yellow
 429     keyword whole day                                      yellow
 430     keyword whole hour                                     yellow
 431     keyword whole minute                                   yellow
 432     keyword whole second                                   yellow
 433     keyword whole weekofyear                               yellow
 434     keyword whole extract                                  yellow
 435     keyword whole datediff                                 yellow
 436     keyword whole date_add                                 yellow
 437     keyword whole date_sub                                 yellow
 438     keyword whole from_utc_timestamp                       yellow
 439     keyword whole to_utc_timestamp                         yellow
 440     keyword whole current_date                             yellow
 441     keyword whole add_months                               yellow
 442     keyword whole last_day                                 yellow
 443     keyword whole next_day                                 yellow
 444     keyword whole trunc                                    yellow
 445     keyword whole months_between                           yellow
 446     keyword whole date_format                              yellow
 447
 448 # Conditional Functions
 449     keyword whole if                                       yellow
 450     keyword whole isnull                                   yellow
 451     keyword whole isnotnull                                yellow
 452     keyword whole coalesce                                 yellow
 453     keyword whole nullif                                   yellow
 454     keyword whole assert_true                              yellow
 455
 456 # String Functions
 457     keyword whole ascii                                    yellow
 458     keyword whole base64                                   yellow
 459     keyword whole character_length                         yellow
 460     keyword whole chr                                      yellow
 461     keyword whole concat                                   yellow
 462     keyword whole context_ngrams                           yellow
 463     keyword whole concat_ws                                yellow
 464     keyword whole decode                                   yellow
 465     keyword whole elt                                      yellow
 466     keyword whole encode                                   yellow
 467     keyword whole field                                    yellow
 468     keyword whole find_in_set                              yellow
 469     keyword whole format_number                            yellow
 470     keyword whole get_json_object                          yellow
 471     keyword whole in_file                                  yellow
 472     keyword whole instr                                    yellow
 473     keyword whole length                                   yellow
 474     keyword whole locate                                   yellow
 475     keyword whole lower                                    yellow
 476     keyword whole lpad                                     yellow
 477     keyword whole ltrim                                    yellow
 478     keyword whole ngrams                                   yellow
 479     keyword whole octet_length                             yellow
 480     keyword whole parse_url                                yellow
 481     keyword whole printf                                   yellow
 482     keyword whole regexp_extract                           yellow
 483     keyword whole regexp_replace                           yellow
 484     keyword whole repeat                                   yellow
 485     keyword whole replace                                  yellow
 486     keyword whole reverse                                  yellow
 487     keyword whole rpad                                     yellow
 488     keyword whole rtrim                                    yellow
 489     keyword whole sentences                                yellow
 490     keyword whole space                                    yellow
 491     keyword whole split                                    yellow
 492     keyword whole str_to_map                               yellow
 493     keyword whole substr                                   yellow
 494     keyword whole substr_index                             yellow
 495     keyword whole translate                                yellow
 496     keyword whole trim                                     yellow
 497     keyword whole unbase64                                 yellow
 498     keyword whole upper                                    yellow
 499     keyword whole initcap                                  yellow
 500     keyword whole levenshtein                              yellow
 501     keyword whole soundex                                  yellow
 502
 503 # Data Masking Functions
 504     keyword whole mask                                     yellow
 505     keyword whole mask_first_n                             yellow
 506     keyword whole mask_last_n                              yellow
 507     keyword whole mask_show_first_n                        yellow
 508     keyword whole mask_show_last_n                         yellow
 509     keyword whole mask_hash                                yellow
 510
 511 # Misc. Functions
 512     keyword whole java_method                              yellow
 513     keyword whole reflect                                  yellow
 514     keyword whole hash                                     yellow
 515     keyword whole current_user                             yellow
 516     keyword whole logged_user                              yellow
 517     keyword whole md5                                      yellow
 518     keyword whole sha1                                     yellow
 519     keyword whole sha                                      yellow
 520     keyword whole crc32                                    yellow
 521     keyword whole sha2                                     yellow
 522     keyword whole aes_encrypt                              yellow
 523     keyword whole aes_decrypt                              yellow
 524     keyword whole version                                  yellow
 525
 526 # xpath
 527     keyword whole xpath                                    yellow
 528     keyword whole xpath_short                              yellow
 529     keyword whole xpath_int                                yellow
 530     keyword whole xpath_long                               yellow
 531     keyword whole xpath_float                              yellow
 532     keyword whole xpath_double                             yellow
 533     keyword whole xpath_number                             yellow
 534     keyword whole xpath_string                             yellow
 535
 536 # Aggregate Functions
 537     keyword whole count                                    yellow
 538     keyword whole sum                                      yellow
 539     keyword whole avg                                      yellow
 540     keyword whole min                                      yellow
 541     keyword whole max                                      yellow
 542     keyword whole variance                                 yellow
 543     keyword whole var_samp                                 yellow
 544     keyword whole stddev_pop                               yellow
 545     keyword whole stddev_samp                              yellow
 546     keyword whole covar_pop                                yellow
 547     keyword whole covar_samp                               yellow
 548     keyword whole corr                                     yellow
 549     keyword whole percentile                               yellow
 550     keyword whole regr_avgx                                yellow
 551     keyword whole regr_avgy                                yellow
 552     keyword whole regr_count                               yellow
 553     keyword whole regr_intercept                           yellow
 554     keyword whole regr_r2                                  yellow
 555     keyword whole regr_slope                               yellow
 556     keyword whole regr_sxx                                 yellow
 557     keyword whole regr_sxy                                 yellow
 558     keyword whole regr_syy                                 yellow
 559     keyword whole histogram_numeric                        yellow
 560     keyword whole collect_set                              yellow
 561     keyword whole collect_list                             yellow
 562     keyword whole ntile                                    yellow
 563
 564 # Table-Generating Functions
 565     keyword whole explode                                  yellow
 566     keyword whole posexplode                               yellow
 567     keyword whole inline                                   yellow
 568     keyword whole stack                                    yellow
 569     keyword whole json_tuple                               yellow
 570     keyword whole parse_url                                yellow
 571
 572 # Window Functions
 573     keyword whole lead                                     yellow
 574     keyword whole lag                                      yellow
 575     keyword whole first_value                              yellow
 576     keyword whole last_value                               yellow
 577     keyword whole rank                                     yellow
 578     keyword whole row_number                               yellow
 579     keyword whole dense_rank                               yellow
 580     keyword whole cume_dist                                yellow
 581     keyword whole percent_rank                             yellow
 582     keyword whole ntile                                    yellow
 583
 584 # Variables
 585     # oozie variables
 586     keyword whole ${+}                                     brightgreen
 587     # hive variables
 588     keyword whole ${hiveconf:+}                            magenta
 589
 590
 591 # Hive options
 592     keyword wholeright hive.+.+.+                          red
 593     keyword wholeright tez.+.+                             red
 594     keyword wholeright mapreduce.+.+                       red
 595
 596 # Literals
 597     # float
 598     keyword whole \[0123456789\]\{.\}\[0123456789\]                                           brightmagenta
 599     # float e notation
 600     keyword whole \[0123456789\]\[.\]\[0123456789\]\{e\}\[\+-\]\{0123456789\}\[0123456789\]   brightmagenta
 601
 602     # tinyint
 603     keyword whole \{0123456789\}\[0123456789\]Y                magenta
 604     # smallint
 605     keyword whole \{0123456789\}\[0123456789\]S                magenta
 606     # bigint
 607     keyword whole \{0123456789\}\[0123456789\]L                magenta
 608     # int
 609     keyword whole \{0123456789\}\[0123456789\]                 brightmagenta
 610     # big decimal
 611     keyword whole \{0123456789\}\[0123456789\]BD               magenta
 612
 613 context exclusive -- \n brown
 614     spellcheck
 615
 616 context exclusive /\* \*/ brown
 617     spellcheck
 618
 619 context ' ' green
 620     keyword \\' brightgreen
 621     # oozie variables
 622     keyword whole ${+}                                         brightgreen
 623     # hive variables
 624     keyword whole ${hiveconf:+}                                magenta
 625
 626 context " " red
 627     keyword \\" brightred