1# Define SciTE settings for SQL, PL/SQL, Apache Hive and Apache Pig files. 2 3file.patterns.sql=*.sql 4file.patterns.plsql=*.spec;*.body;*.sps;*.spb;*.sf;*.sp 5file.patterns.hql=*.hql 6file.patterns.pig=*.pig 7 8lexer.$(file.patterns.sql)=sql 9lexer.$(file.patterns.plsql)=sql 10lexer.$(file.patterns.hql)=sql 11lexer.$(file.patterns.pig)=sql 12 13file.patterns.sql.like=$(file.patterns.sql);$(file.patterns.plsql);$(file.patterns.hql);$(file.patterns.pig) 14 15*source.patterns.sql=$(file.patterns.sql.like); 16 17filter.sql=SQL (sql)|$(file.patterns.sql.like)| 18 19*filter.sql=$(filter.sql) 20 21*language.sql=S&QL|sql|| 22 23#*language.plsql=P&LSQL|spec|| 24#*language.hql=Hive SQL|hql|| 25#*language.pig=Pig Query|pig|| 26 27# SQL comments 28comment.block.sql=-- 29#comment.block.at.line.start.sql=1 30comment.stream.start.sql=/* 31comment.stream.end.sql=*/ 32comment.box.start.sql=/* 33comment.box.middle.sql= * 34comment.box.end.sql= */ 35 36# SQL styles 37# White space 38style.sql.0=fore:#808080 39# Comment 40style.sql.1=fore:#007F00,$(font.comment) 41# Line Comment 42style.sql.2=fore:#007F00,$(font.comment) 43# Doc comment 44style.sql.3=fore:#7F7F7F 45# Number 46style.sql.4=fore:#007F7F 47# Keyword 48style.sql.5=fore:#00007F,bold 49# Double quoted string 50style.sql.6=fore:#7F007F,$(font.monospace) 51# Single quoted string 52style.sql.7=fore:#7F007F,$(font.monospace) 53# SQL*Plus 54style.sql.8=$(colour.preproc) 55# SQL*Plus PROMPT 56style.sql.9=fore:#007F00,$(font.monospace),back:#E0FFE0,eolfilled 57# Operators 58style.sql.10=bold 59# Identifiers 60style.sql.11= 61# Not used 62#style.sql.12=fore:#000000,$(font.monospace),back:#E0C0E0,eolfilled 63# SQL*Plus Comment 64style.sql.13=fore:#007F00,$(font.comment) 65# not used 66# style.sql.14= 67# Hash Line Comment 68style.sql.15=fore:#007F00,$(font.comment) 69# Keywords2: Database objects 70style.sql.16=fore:#B00040 71# Comment Doc Keyword 72style.sql.17=fore:#3060A0,$(font.code.comment.doc) 73# Comment Doc Keyword Error 74style.sql.18=fore:#804020,$(font.code.comment.doc) 75# Keywords5: User Keywords 1 76style.sql.19=fore:#4B0082 77# Keywords6: User Keywords 2 78style.sql.20=fore:#B00040 79# Keywords7: User Keywords 3 80style.sql.21=fore:#8B0000 81# Keywords8: User Keywords 4 82style.sql.22=fore:#800080 83# Quoted identifier 84style.sql.23=fore:#DD9900 85# Q operator 86style.sql.24=fore:#EE00AA 87 88# Braces are only matched in operator style 89braces.sql.style=10 90# Enables backslash as an escape character 91#sql.backslash.escapes=1 92 93# Activate '#' based comments for MySQL with 1 or disable for Oracle with 0: 94#lexer.sql.numbersign.comment=0 95 96# Set to 1 to colourise recognized words with dots 97# (recommended for Oracle PL/SQL objects) 98#lexer.sql.allow.dotted.word=1 99 100#lexer.sql.backticks.identifier=1 101 102keywords.$(file.patterns.sql)=\ 103absolute action add admin after aggregate \ 104alias all allocate alter and any are array as asc \ 105assertion at authorization \ 106before begin binary bit blob body boolean both breadth by \ 107call cascade cascaded case cast catalog char character \ 108check class clob close collate collation column commit \ 109completion connect connection constraint constraints \ 110constructor continue corresponding create cross cube current \ 111current_date current_path current_role current_time current_timestamp \ 112current_user cursor cycle \ 113data date datetime day deallocate dec decimal declare default \ 114deferrable deferred delete depth deref desc describe descriptor \ 115destroy destructor deterministic dictionary diagnostics disconnect \ 116distinct domain double drop dynamic \ 117each else end end-exec equals escape every except \ 118exception exec execute exists exit external \ 119false fetch first float for foreign found from free full \ 120function \ 121general get global go goto grant group grouping \ 122having host hour \ 123identity if ignore immediate in indicator initialize initially \ 124inner inout input insert int integer intersect interval \ 125into is isolation iterate \ 126join \ 127key \ 128language large last lateral leading left less level like \ 129limit local localtime localtimestamp locator \ 130map match merge minute modifies modify module month \ 131names national natural nchar nclob new next no none \ 132not null numeric \ 133object of off old on only open operation option \ 134or order ordinality out outer output \ 135package pad parameter parameters partial path postfix precision prefix \ 136preorder prepare preserve primary \ 137prior privileges procedure public \ 138read reads real recursive ref references referencing relative \ 139restrict result return returns revoke right \ 140role rollback rollup routine row rows \ 141savepoint schema scroll scope search second section select \ 142sequence session session_user set sets size smallint some| space \ 143specific specifictype sql sqlexception sqlstate sqlwarning start \ 144state statement static structure system_user \ 145table temporary terminate than then time timestamp \ 146timezone_hour timezone_minute to trailing transaction translation \ 147treat trigger true \ 148under union unique unknown \ 149unnest update usage user using \ 150value values varchar variable varying view \ 151when whenever where with without work write \ 152year \ 153zone 154 155keywords.$(file.patterns.plsql)=\ 156all alter and any array as asc at authid avg begin between \ 157binary_integer \ 158body boolean bulk by char char_base check close cluster collect \ 159comment commit compress connect constant create current currval \ 160cursor date day declare decimal default delete desc distinct \ 161do drop else elsif end exception exclusive execute exists exit \ 162extends false fetch float for forall from function goto group \ 163having heap hour if immediate in index indicator insert integer \ 164interface intersect interval into is isolation java level like \ 165limited lock long loop max min minus minute mlslabel mod mode \ 166month natural naturaln new nextval nocopy not nowait null number \ 167number_base ocirowid of on opaque open operator option or order \ 168organization others out package partition pctfree pls_integer \ 169positive positiven pragma prior private procedure public raise \ 170range raw real record ref release return reverse rollback row \ 171rowid rownum rowtype savepoint second select separate set share \ 172smallint space sql sqlcode sqlerrm start stddev subtype successful \ 173sum synonym sysdate table then time timestamp to trigger true \ 174type uid union unique update use user validate values varchar \ 175varchar2 variance view when whenever where while with work write \ 176year zone 177 178# Keywords for PlDoc comments 179keywords3.$(file.patterns.sql)=\ 180param author since return see deprecated todo 181 182# Keywords for SQL*Plus 183keywords4.$(file.patterns.sql)=\ 184acc~ept a~ppend archive log attribute \ 185bre~ak bti~tle \ 186c~hange cl~ear col~umn comp~ute conn~ect copy \ 187def~ine del desc~ribe disc~onnect \ 188e~dit exec~ute exit \ 189get \ 190help ho~st \ 191i~nput \ 192l~ist \ 193passw~ord pau~se pri~nt pro~mpt \ 194quit \ 195recover rem~ark repf~ooter reph~eader r~un \ 196sav~e set sho~w shutdown spo~ol sta~rt startup store \ 197timi~ng tti~tle \ 198undef~ine \ 199var~iable \ 200whenever oserror whenever sqlerror \ 201 202# User keywords 1 203# Keywords for Standard packages 204keywords5.$(file.patterns.sql)=\ 205dbms_output.disable dbms_output.enable dbms_output.get_line \ 206dbms_output.get_lines dbms_output.new_line dbms_output.put \ 207dbms_output.put_line \ 208 209 210# Reserved Keywords for Apache Hive SQL 211keywords.$(file.patterns.hql)=\ 212all alter and as authorization between both by \ 213case cast column conf create cross cube current \ 214cursor database delete describe distinct \ 215drop else end exchange exists extended external fetch following \ 216for from full function grant group grouping having if import in inner insert \ 217intersect interval into is join lateral left less like local macro map \ 218more not of on or order out outer over partialscan partition percent \ 219preceding preserve procedure range reads reduce revoke right rollup row rows \ 220select set table tablesample then to transform trigger \ 221truncate unbounded union uniquejoin update user using values \ 222when where window with commit only regexp rlike rollback start \ 223cache constraint foreign primary references \ 224extract floor precision views \ 225sync 226 227# User keywords 2 228# Reserved Keywords for Apache Hive SQL 229keywords6.$(file.patterns.hql)=\ 230add admin after analyze archive asc before bucket buckets cascade change \ 231cluster clustered clusterstatus collection columns comment compact compactions \ 232compute concatenate continue data databases dbproperties deferred \ 233defined delimited dependency desc directories directory disable distribute \ 234elem_type enable escaped exclusive explain export fields file fileformat first \ 235format formatted functions hold_ddltime idxproperties ignore index \ 236indexes inpath inputdriver inputformat items jar keys key_type limit lines \ 237load location lock locks logical mapjoin materialized metadata minus \ 238msck noscan no_drop offline option outputdriver outputformat \ 239overwrite owner partitioned partitions plus pretty principals protection purge \ 240read readonly rebuild recordreader recordwriter regexp reload rename repair \ 241replace replication restrict rewrite rlike role roles schema schemas \ 242semi serde serdeproperties server sets shared show show_database skewed sort \ 243sorted ssl statistics stored streamtable tables tblproperties \ 244temporary terminated touch transactions unarchive undo uniontype \ 245unlock unset uri use utc value_type view while \ 246autocommit isolation level offset snapshot transaction work write \ 247abort key last norely novalidate nulls rely validate \ 248detail expression operator quarter summary vectorization \ 249zone 250 251# User keywords 3 252# Column/Field Types for Apache Hive SQL 253keywords7.$(file.patterns.hql)=\ 254array bigint boolean char date decimal double float int smallint timestamp \ 255utc_tmestamp varchar integer time numeric \ 256datetime long string struct tinyint timestamptz unsigned utctimestamp 257 258# Functions for Apache Hive SQL 259keywords4.$(file.patterns.hql)=\ 260round floor ceil rand exp ln log10 log2 log pow sqrt bin hex unhex conv abs \ 261pmod sin asin cos acos tan atan degrees radians positive negative sign e pi \ 262size map_keys map_values array_contains sort_array \ 263binary cast \ 264from_unixtime unix_timestamp to_date datediff date_add date_sub \ 265from_utc_timestamp to_utc_timestamp \ 266day hour minute second month year weekofyear \ 267if case coalesce nullif \ 268ascii concat concat_ws context_ngrams find_in_set format_number \ 269get_json_object in_file instr length locate lower lpad ltrim ngrams parse_url \ 270printf regexp_extract regexp_replace repeat reverse rpad rtrim sentences \ 271space split str_to_map substr substring translate trim upper \ 272hash 273 274# User keywords 4 275# Constants Types for Apache Hive SQL 276keywords8.$(file.patterns.hql)=\ 277current_timestamp false none null true dayofweek \ 278dow week years months weeks days hours minutes seconds \ 279orc csv parquet rc 280 281# User keywords 1 282# Reserved Keywords for Apache PIG 283keywords.$(file.patterns.pig)=\ 284and any all arrange as asc by cache case \ 285%declare %default dense desc else end eval flatten full generate if \ 286inner input in into is left matches not onschema or outer output \ 287parallel partition returns right rollup ship stderr stdin stdout then \ 288through using when 289 290# User keywords 2 291# Operators for Apache PIG 292keywords6.$(file.patterns.pig)=\ 293assert cogroup cross cube define distinct filter foreach group import join \ 294limit load native order rank sample split set store stream union register 295 296# User keywords 3 297# Column/Field/Storage Types for Apache PIG 298keywords7.$(file.patterns.pig)=\ 299int long float double chararray bytearray boolean datetime biginteger bigdecimal \ 300tuple bag map \ 301pigstorage pigdump jsonloader jsonstorage avrostorage orcstorage textloader \ 302hbasestorage trevnistorage accumulostorage 303 304# User keywords 4 305# Constants Types for Apache PIG 306keywords8.$(file.patterns.pig)=\ 307true false null void 308 309# Functions for Apache PIG 310keywords4.$(file.patterns.pig)=\ 311avg bagtostring bagtotuple bloom buildbloom concat count count_star diff \ 312isempty max min plucktuple size subtract sum tokenize \ 313abs acos asin atan cbrt ceil cos cosh exp floor log log10 random round \ 314round_to sin sinh sqrt tan tanh \ 315endswith equalsignorecase indexof last_index_of lcfirst lower ltrim \ 316regex_extract regex_extract_all regex_search replace rtrim sprintf startswith \ 317strsplit strsplittobag substring trim ucfirst upper \ 318uniqueid addduration currenttime daysbetween getday gethour getmillisecond \ 319getminute getmonth getsecond getweek getweekyear getyear hoursbetween \ 320millisecondsbetween minutesbetween monthsbetween secondsbetween \ 321subtractduration todate tomilliseconds tostring tounixtime weeksbetween \ 322yearsbetween \ 323totuple tobag tomap top 324 325# User keywords 1 326# Commands for Apache PIG 327keywords5.$(file.patterns.pig)=\ 328cat cd cp du ls mkdir mv pwd rm rmf \ 329copyfromlocal copytolocal pig \ 330fs sh clear exec help history kill quit run \ 331describe dump explain illustrate 332 333