mc/source
0
0
Fork 0
mirror of https://github.com/MidnightCommander/source.git synced 2026-02-02 11:11:55 -08:00
Code Issues Packages Projects Releases Wiki Activity
Files
gh-pages
source/S/misc--syntax--hive.syntax.html
github-actions[bot] 08571174ab Deploy to GitHub Pages
2026-02-01 17:32:02 +00:00

662 lines
57 KiB
HTML
Raw Permalink Blame History

<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head>
<title>misc/syntax/hive.syntax</title>
<meta name='robots' content='noindex,nofollow' />
<meta name='generator' content='GLOBAL-6.6.11' />
<meta http-equiv='Content-Style-Type' content='text/css' />
<link rel='stylesheet' type='text/css' href='../style.css' />
</head>
<body>
<!-- beginning of fixed guide -->
<div id='guide'><ul>
<li><a href='#TOP'><img class='icon' src='../icons/first.png' alt='[^]' /></a></li>
<li><a href='#BOTTOM'><img class='icon' src='../icons/last.png' alt='[v]' /></a></li>
<li><a href='#TOP'><img class='icon' src='../icons/top.png' alt='[top]' /></a></li>
<li><a href='#BOTTOM'><img class='icon' src='../icons/bottom.png' alt='[bottom]' /></a></li>
<li><a href='../mains.html'><img class='icon' src='../icons/index.png' alt='[index]' /></a></li>
<li><a href='../help.html'><img class='icon' src='../icons/help.png' alt='[help]' /></a></li>
<li class='standout'><span><a href='../files/misc.html'>misc</a>/<a href='../files/misc--syntax.html'>syntax</a>/hive.syntax</span></li>
</ul></div>
<!-- end of fixed guide -->
<div align='right'>Manual pages:
<a href=man/mc.html>mc</a> &bullet; <a href=man/mcdiff.html>mcdiff</a> &bullet; <a href=man/mcedit.html>mcedit</a> &bullet; <a href=man/mcview.html>mcview</a>
</div>
<a id='TOP' name='TOP'></a><h2 class='header'><a href='../mains.html'>root</a>/<a href='../files/misc.html'>misc</a>/<a href='../files/misc--syntax.html'>syntax</a>/hive.syntax</h2>
<em class='comment'>/* <img class='icon' src='../icons/n_left.png' alt='[previous]' /><img class='icon' src='../icons/n_right.png' alt='[next]' /><img class='icon' src='../icons/n_first.png' alt='[first]' /><img class='icon' src='../icons/n_last.png' alt='[last]' /><img class='icon' src='../icons/n_top.png' alt='[top]' /><a href='#BOTTOM'><img class='icon' src='../icons/bottom.png' alt='[bottom]' /></a><a href='../mains.html'><img class='icon' src='../icons/index.png' alt='[index]' /></a><a href='../help.html'><img class='icon' src='../icons/help.png' alt='[help]' /></a>&nbsp;<input type='text' readonly onfocus='this.select();' value='+1 misc/syntax/hive.syntax' /> */</em>
<hr />
<pre>
<a id='L1' name='L1'></a># HQL syntax highlighting
<a id='L2' name='L2'></a># by Michal Lorek &lt;michal.lorek@gmail.com&gt;
<a id='L3' name='L3'></a>
<a id='L4' name='L4'></a>caseinsensitive
<a id='L5' name='L5'></a>
<a id='L6' name='L6'></a>context default
<a id='L7' name='L7'></a>
<a id='L8' name='L8'></a># Keywords
<a id='L9' name='L9'></a> keyword whole TRUE white
<a id='L10' name='L10'></a> keyword whole FALSE white
<a id='L11' name='L11'></a> keyword whole ALL white
<a id='L12' name='L12'></a> keyword whole NONE white
<a id='L13' name='L13'></a> keyword whole AND white
<a id='L14' name='L14'></a> keyword whole OR white
<a id='L15' name='L15'></a> keyword whole NOT white
<a id='L16' name='L16'></a> keyword whole ! brightcyan
<a id='L17' name='L17'></a> keyword whole LIKE white
<a id='L18' name='L18'></a> keyword whole ANY white
<a id='L19' name='L19'></a> keyword whole IF white
<a id='L20' name='L20'></a> keyword whole EXISTS white
<a id='L21' name='L21'></a> keyword whole ASC white
<a id='L22' name='L22'></a> keyword whole DESC white
<a id='L23' name='L23'></a> keyword whole NULLS white
<a id='L24' name='L24'></a> keyword whole LAST white
<a id='L25' name='L25'></a> keyword whole ORDER white
<a id='L26' name='L26'></a> keyword whole GROUP white
<a id='L27' name='L27'></a> keyword whole BY white
<a id='L28' name='L28'></a> keyword whole HAVING white
<a id='L29' name='L29'></a> keyword whole WHERE white
<a id='L30' name='L30'></a> keyword whole FROM white
<a id='L31' name='L31'></a> keyword whole AS white
<a id='L32' name='L32'></a> keyword whole SELECT white
<a id='L33' name='L33'></a> keyword whole DISTINCT white
<a id='L34' name='L34'></a> keyword whole INSERT white
<a id='L35' name='L35'></a> keyword whole OVERWRITE magenta
<a id='L36' name='L36'></a> keyword whole OUTER white
<a id='L37' name='L37'></a> keyword whole UNIQUEJOIN white
<a id='L38' name='L38'></a> keyword whole PRESERVE white
<a id='L39' name='L39'></a> keyword whole JOIN white
<a id='L40' name='L40'></a> keyword whole LEFT white
<a id='L41' name='L41'></a> keyword whole RIGHT white
<a id='L42' name='L42'></a> keyword whole FULL white
<a id='L43' name='L43'></a> keyword whole ON white
<a id='L44' name='L44'></a> keyword whole PARTITION white
<a id='L45' name='L45'></a> keyword whole PARTITIONS white
<a id='L46' name='L46'></a> keyword whole TABLE white
<a id='L47' name='L47'></a> keyword whole TABLES white
<a id='L48' name='L48'></a> keyword whole COLUMNS white
<a id='L49' name='L49'></a> keyword whole INDEX white
<a id='L50' name='L50'></a> keyword whole INDEXES white
<a id='L51' name='L51'></a> keyword whole REBUILD white
<a id='L52' name='L52'></a> keyword whole FUNCTIONS white
<a id='L53' name='L53'></a> keyword whole SHOW white
<a id='L54' name='L54'></a> keyword whole MSCK white
<a id='L55' name='L55'></a> keyword whole REPAIR white
<a id='L56' name='L56'></a> keyword whole DIRECTORY magenta
<a id='L57' name='L57'></a> keyword whole LOCAL magenta
<a id='L58' name='L58'></a> keyword whole TRANSFORM white
<a id='L59' name='L59'></a> keyword whole USING white
<a id='L60' name='L60'></a> keyword whole CLUSTER white
<a id='L61' name='L61'></a> keyword whole DISTRIBUTE white
<a id='L62' name='L62'></a> keyword whole SORT white
<a id='L63' name='L63'></a> keyword whole UNION white
<a id='L64' name='L64'></a> keyword whole EXCEPT white
<a id='L65' name='L65'></a> keyword whole LOAD white
<a id='L66' name='L66'></a> keyword whole EXPORT white
<a id='L67' name='L67'></a> keyword whole IMPORT white
<a id='L68' name='L68'></a> keyword whole REPLICATION white
<a id='L69' name='L69'></a> keyword whole METADATA white
<a id='L70' name='L70'></a> keyword whole DATA white
<a id='L71' name='L71'></a> keyword whole INPATH white
<a id='L72' name='L72'></a> keyword whole IS white
<a id='L73' name='L73'></a> keyword whole NULL white
<a id='L74' name='L74'></a> keyword whole CREATE white
<a id='L75' name='L75'></a> keyword whole EXTERNAL white
<a id='L76' name='L76'></a> keyword whole ALTER white
<a id='L77' name='L77'></a> keyword whole CHANGE white
<a id='L78' name='L78'></a> keyword whole COLUMN white
<a id='L79' name='L79'></a> keyword whole FIRST white
<a id='L80' name='L80'></a> keyword whole AFTER white
<a id='L81' name='L81'></a> keyword whole DESCRIBE magenta
<a id='L82' name='L82'></a> keyword whole DROP white
<a id='L83' name='L83'></a> keyword whole RENAME white
<a id='L84' name='L84'></a> keyword whole TO white
<a id='L85' name='L85'></a> keyword whole COMMENT white
<a id='L86' name='L86'></a> keyword whole BOOLEAN white
<a id='L87' name='L87'></a> keyword whole TINYINT white
<a id='L88' name='L88'></a> keyword whole SMALLINT white
<a id='L89' name='L89'></a> keyword whole INT white
<a id='L90' name='L90'></a> keyword whole INTEGER white
<a id='L91' name='L91'></a> keyword whole BIGINT white
<a id='L92' name='L92'></a> keyword whole FLOAT white
<a id='L93' name='L93'></a> keyword whole DOUBLE white
<a id='L94' name='L94'></a> keyword whole PRECISION white
<a id='L95' name='L95'></a> keyword whole DATE white
<a id='L96' name='L96'></a> keyword whole DATETIME white
<a id='L97' name='L97'></a> keyword whole TIMESTAMP white
<a id='L98' name='L98'></a> keyword whole TIMESTAMPTZ white
<a id='L99' name='L99'></a> keyword whole TIME white
<a id='L100' name='L100'></a> keyword whole ZONE white
<a id='L101' name='L101'></a> keyword whole INTERVAL white
<a id='L102' name='L102'></a> keyword whole DECIMAL white
<a id='L103' name='L103'></a> keyword whole DEC white
<a id='L104' name='L104'></a> keyword whole NUMERIC white
<a id='L105' name='L105'></a> keyword whole STRING white
<a id='L106' name='L106'></a> keyword whole CHAR white
<a id='L107' name='L107'></a> keyword whole VARCHAR white
<a id='L108' name='L108'></a> keyword whole ARRAY white
<a id='L109' name='L109'></a> keyword whole STRUCT white
<a id='L110' name='L110'></a> keyword whole MAP white
<a id='L111' name='L111'></a> keyword whole UNIONTYPE white
<a id='L112' name='L112'></a> keyword whole REDUCE white
<a id='L113' name='L113'></a> keyword whole PARTITIONED white
<a id='L114' name='L114'></a> keyword whole CLUSTERED white
<a id='L115' name='L115'></a> keyword whole SORTED white
<a id='L116' name='L116'></a> keyword whole INTO white
<a id='L117' name='L117'></a> keyword whole BUCKETS white
<a id='L118' name='L118'></a> keyword whole ROW magenta
<a id='L119' name='L119'></a> keyword whole ROWS magenta
<a id='L120' name='L120'></a> keyword whole FORMAT magenta
<a id='L121' name='L121'></a> keyword whole DELIMITED magenta
<a id='L122' name='L122'></a> keyword whole FIELDS magenta
<a id='L123' name='L123'></a> keyword whole TERMINATED magenta
<a id='L124' name='L124'></a> keyword whole ESCAPED magenta
<a id='L125' name='L125'></a> keyword whole COLLECTION white
<a id='L126' name='L126'></a> keyword whole ITEMS white
<a id='L127' name='L127'></a> keyword whole KEYS white
<a id='L128' name='L128'></a> keyword whole $KEY$ white
<a id='L129' name='L129'></a> keyword whole LINES magenta
<a id='L130' name='L130'></a> keyword whole STORED magenta
<a id='L131' name='L131'></a> keyword whole FILEFORMAT magenta
<a id='L132' name='L132'></a> keyword whole INPUTFORMAT magenta
<a id='L133' name='L133'></a> keyword whole OUTPUTFORMAT magenta
<a id='L134' name='L134'></a> keyword whole INPUTDRIVER white
<a id='L135' name='L135'></a> keyword whole OUTPUTDRIVER white
<a id='L136' name='L136'></a> keyword whole ENABLE white
<a id='L137' name='L137'></a> keyword whole DISABLE white
<a id='L138' name='L138'></a> keyword whole LOCATION magenta
<a id='L139' name='L139'></a> keyword whole TABLESAMPLE white
<a id='L140' name='L140'></a> keyword whole BUCKET white
<a id='L141' name='L141'></a> keyword whole OUT white
<a id='L142' name='L142'></a> keyword whole OF white
<a id='L143' name='L143'></a> keyword whole PERCENT white
<a id='L144' name='L144'></a> keyword whole CAST cyan
<a id='L145' name='L145'></a> keyword whole ADD white
<a id='L146' name='L146'></a> keyword whole REPLACE white
<a id='L147' name='L147'></a> keyword whole RLIKE white
<a id='L148' name='L148'></a> keyword whole REGEXP white
<a id='L149' name='L149'></a> keyword whole TEMPORARY white
<a id='L150' name='L150'></a> keyword whole FUNCTION white
<a id='L151' name='L151'></a> keyword whole MACRO white
<a id='L152' name='L152'></a> keyword whole FILE white
<a id='L153' name='L153'></a> keyword whole JAR white
<a id='L154' name='L154'></a> keyword whole EXPLAIN white
<a id='L155' name='L155'></a> keyword whole EXTENDED white
<a id='L156' name='L156'></a> keyword whole FORMATTED white
<a id='L157' name='L157'></a> keyword whole PRETTY white
<a id='L158' name='L158'></a> keyword whole DEPENDENCY white
<a id='L159' name='L159'></a> keyword whole LOGICAL white
<a id='L160' name='L160'></a> keyword whole SERDE white
<a id='L161' name='L161'></a> keyword whole WITH white
<a id='L162' name='L162'></a> keyword whole DEFERRED white
<a id='L163' name='L163'></a> keyword whole SERDEPROPERTIES white
<a id='L164' name='L164'></a> keyword whole DBPROPERTIES white
<a id='L165' name='L165'></a> keyword whole LIMIT white
<a id='L166' name='L166'></a> keyword whole OFFSET white
<a id='L167' name='L167'></a> keyword whole SET white
<a id='L168' name='L168'></a> keyword whole UNSET white
<a id='L169' name='L169'></a> keyword whole TBLPROPERTIES white
<a id='L170' name='L170'></a> keyword whole IDXPROPERTIES white
<a id='L171' name='L171'></a> keyword whole $VALUE$ white
<a id='L172' name='L172'></a> keyword whole $ELEM$ white
<a id='L173' name='L173'></a> keyword whole DEFINED white
<a id='L174' name='L174'></a> keyword whole CASE white
<a id='L175' name='L175'></a> keyword whole WHEN white
<a id='L176' name='L176'></a> keyword whole THEN white
<a id='L177' name='L177'></a> keyword whole ELSE white
<a id='L178' name='L178'></a> keyword whole END white
<a id='L179' name='L179'></a> keyword whole MAPJOIN white
<a id='L180' name='L180'></a> keyword whole STREAMTABLE white
<a id='L181' name='L181'></a> keyword whole CLUSTERSTATUS white
<a id='L182' name='L182'></a> keyword whole UTC white
<a id='L183' name='L183'></a> keyword whole UTC_TMESTAMP white
<a id='L184' name='L184'></a> keyword whole LONG white
<a id='L185' name='L185'></a> keyword whole DELETE white
<a id='L186' name='L186'></a> keyword whole PLUS white
<a id='L187' name='L187'></a> keyword whole MINUS white
<a id='L188' name='L188'></a> keyword whole FETCH white
<a id='L189' name='L189'></a> keyword whole INTERSECT white
<a id='L190' name='L190'></a> keyword whole VIEW white
<a id='L191' name='L191'></a> keyword whole VIEWS white
<a id='L192' name='L192'></a> keyword whole IN white
<a id='L193' name='L193'></a> keyword whole DATABASE white
<a id='L194' name='L194'></a> keyword whole DATABASES white
<a id='L195' name='L195'></a> keyword whole MATERIALIZED white
<a id='L196' name='L196'></a> keyword whole SCHEMA white
<a id='L197' name='L197'></a> keyword whole SCHEMAS white
<a id='L198' name='L198'></a> keyword whole GRANT white
<a id='L199' name='L199'></a> keyword whole REVOKE white
<a id='L200' name='L200'></a> keyword whole SSL white
<a id='L201' name='L201'></a> keyword whole UNDO white
<a id='L202' name='L202'></a> keyword whole LOCK white
<a id='L203' name='L203'></a> keyword whole LOCKS white
<a id='L204' name='L204'></a> keyword whole UNLOCK white
<a id='L205' name='L205'></a> keyword whole SHARED white
<a id='L206' name='L206'></a> keyword whole EXCLUSIVE white
<a id='L207' name='L207'></a> keyword whole PROCEDURE white
<a id='L208' name='L208'></a> keyword whole UNSIGNED white
<a id='L209' name='L209'></a> keyword whole WHILE white
<a id='L210' name='L210'></a> keyword whole READ white
<a id='L211' name='L211'></a> keyword whole READS white
<a id='L212' name='L212'></a> keyword whole PURGE white
<a id='L213' name='L213'></a> keyword whole RANGE white
<a id='L214' name='L214'></a> keyword whole ANALYZE white
<a id='L215' name='L215'></a> keyword whole BEFORE white
<a id='L216' name='L216'></a> keyword whole BETWEEN white
<a id='L217' name='L217'></a> keyword whole BOTH white
<a id='L218' name='L218'></a> keyword whole BINARY white
<a id='L219' name='L219'></a> keyword whole CROSS white
<a id='L220' name='L220'></a> keyword whole CONTINUE white
<a id='L221' name='L221'></a> keyword whole CURSOR white
<a id='L222' name='L222'></a> keyword whole TRIGGER white
<a id='L223' name='L223'></a> keyword whole RECORDREADER white
<a id='L224' name='L224'></a> keyword whole RECORDWRITER white
<a id='L225' name='L225'></a> keyword whole SEMI white
<a id='L226' name='L226'></a> keyword whole LATERAL magenta
<a id='L227' name='L227'></a> keyword whole TOUCH white
<a id='L228' name='L228'></a> keyword whole ARCHIVE magenta
<a id='L229' name='L229'></a> keyword whole UNARCHIVE magenta
<a id='L230' name='L230'></a> keyword whole COMPUTE white
<a id='L231' name='L231'></a> keyword whole STATISTICS white
<a id='L232' name='L232'></a> keyword whole USE magenta
<a id='L233' name='L233'></a> keyword whole OPTION white
<a id='L234' name='L234'></a> keyword whole CONCATENATE magenta
<a id='L235' name='L235'></a> keyword whole SHOW_DATABASE white
<a id='L236' name='L236'></a> keyword whole UPDATE white
<a id='L237' name='L237'></a> keyword whole RESTRICT white
<a id='L238' name='L238'></a> keyword whole CASCADE white
<a id='L239' name='L239'></a> keyword whole SKEWED white
<a id='L240' name='L240'></a> keyword whole ROLLUP white
<a id='L241' name='L241'></a> keyword whole CUBE white
<a id='L242' name='L242'></a> keyword whole DIRECTORIES white
<a id='L243' name='L243'></a> keyword whole FOR white
<a id='L244' name='L244'></a> keyword whole WINDOW white
<a id='L245' name='L245'></a> keyword whole UNBOUNDED white
<a id='L246' name='L246'></a> keyword whole PRECEDING white
<a id='L247' name='L247'></a> keyword whole FOLLOWING white
<a id='L248' name='L248'></a> keyword whole CURRENT white
<a id='L249' name='L249'></a> keyword whole CURRENT_DATE white
<a id='L250' name='L250'></a> keyword whole CURRENT_TIMESTAMP white
<a id='L251' name='L251'></a> keyword whole LESS white
<a id='L252' name='L252'></a> keyword whole MORE white
<a id='L253' name='L253'></a> keyword whole OVER white
<a id='L254' name='L254'></a> keyword whole GROUPING white
<a id='L255' name='L255'></a> keyword whole SETS white
<a id='L256' name='L256'></a> keyword whole TRUNCATE white
<a id='L257' name='L257'></a> keyword whole NOSCAN white
<a id='L258' name='L258'></a> keyword whole PARTIALSCAN white
<a id='L259' name='L259'></a> keyword whole USER white
<a id='L260' name='L260'></a> keyword whole ROLE white
<a id='L261' name='L261'></a> keyword whole ROLES white
<a id='L262' name='L262'></a> keyword whole INNER white
<a id='L263' name='L263'></a> keyword whole EXCHANGE white
<a id='L264' name='L264'></a> keyword whole URI white
<a id='L265' name='L265'></a> keyword whole SERVER white
<a id='L266' name='L266'></a> keyword whole ADMIN white
<a id='L267' name='L267'></a> keyword whole OWNER white
<a id='L268' name='L268'></a> keyword whole PRINCIPALS white
<a id='L269' name='L269'></a> keyword whole COMPACT white
<a id='L270' name='L270'></a> keyword whole COMPACTIONS white
<a id='L271' name='L271'></a> keyword whole TRANSACTIONS white
<a id='L272' name='L272'></a> keyword whole REWRITE white
<a id='L273' name='L273'></a> keyword whole AUTHORIZATION white
<a id='L274' name='L274'></a> keyword whole CONF white
<a id='L275' name='L275'></a> keyword whole VALUES white
<a id='L276' name='L276'></a> keyword whole RELOAD white
<a id='L277' name='L277'></a> keyword whole YEAR white
<a id='L278' name='L278'></a> keyword whole YEARS white
<a id='L279' name='L279'></a> keyword whole QUARTER white
<a id='L280' name='L280'></a> keyword whole MONTH white
<a id='L281' name='L281'></a> keyword whole MONTHS white
<a id='L282' name='L282'></a> keyword whole WEEK white
<a id='L283' name='L283'></a> keyword whole WEEKS white
<a id='L284' name='L284'></a> keyword whole DAY white
<a id='L285' name='L285'></a> keyword whole DAYS white
<a id='L286' name='L286'></a> keyword whole DAYOFWEEK white
<a id='L287' name='L287'></a> keyword whole HOUR white
<a id='L288' name='L288'></a> keyword whole HOURS white
<a id='L289' name='L289'></a> keyword whole MINUTE white
<a id='L290' name='L290'></a> keyword whole MINUTES white
<a id='L291' name='L291'></a> keyword whole SECOND white
<a id='L292' name='L292'></a> keyword whole SECONDS white
<a id='L293' name='L293'></a> keyword whole START white
<a id='L294' name='L294'></a> keyword whole TRANSACTION white
<a id='L295' name='L295'></a> keyword whole COMMIT white
<a id='L296' name='L296'></a> keyword whole ROLLBACK white
<a id='L297' name='L297'></a> keyword whole WORK white
<a id='L298' name='L298'></a> keyword whole ONLY white
<a id='L299' name='L299'></a> keyword whole WRITE white
<a id='L300' name='L300'></a> keyword whole ISOLATION white
<a id='L301' name='L301'></a> keyword whole LEVEL white
<a id='L302' name='L302'></a> keyword whole SNAPSHOT white
<a id='L303' name='L303'></a> keyword whole AUTOCOMMIT white
<a id='L304' name='L304'></a> keyword whole CACHE white
<a id='L305' name='L305'></a> keyword whole PRIMARY white
<a id='L306' name='L306'></a> keyword whole FOREIGN white
<a id='L307' name='L307'></a> keyword whole REFERENCES white
<a id='L308' name='L308'></a> keyword whole CONSTRAINT white
<a id='L309' name='L309'></a> keyword whole VALIDATE white
<a id='L310' name='L310'></a> keyword whole NOVALIDATE white
<a id='L311' name='L311'></a> keyword whole RELY white
<a id='L312' name='L312'></a> keyword whole NORELY white
<a id='L313' name='L313'></a> keyword whole UNIQUE white
<a id='L314' name='L314'></a> keyword whole KEY white
<a id='L315' name='L315'></a> keyword whole ABORT white
<a id='L316' name='L316'></a> keyword whole EXTRACT white
<a id='L317' name='L317'></a> keyword whole FLOOR white
<a id='L318' name='L318'></a> keyword whole MERGE white
<a id='L319' name='L319'></a> keyword whole MATCHED white
<a id='L320' name='L320'></a> keyword whole REPL white
<a id='L321' name='L321'></a> keyword whole DUMP white
<a id='L322' name='L322'></a> keyword whole STATUS white
<a id='L323' name='L323'></a> keyword whole VECTORIZATION white
<a id='L324' name='L324'></a> keyword whole SUMMARY white
<a id='L325' name='L325'></a> keyword whole OPERATOR white
<a id='L326' name='L326'></a> keyword whole EXPRESSION white
<a id='L327' name='L327'></a> keyword whole DETAIL white
<a id='L328' name='L328'></a> keyword whole WAIT white
<a id='L329' name='L329'></a>
<a id='L330' name='L330'></a># Storage Formats
<a id='L331' name='L331'></a> keyword whole TEXTFILE brightblue
<a id='L332' name='L332'></a> keyword whole ORC brightblue
<a id='L333' name='L333'></a> keyword whole SEQUENCEFILE brightblue
<a id='L334' name='L334'></a> keyword whole RCFILE brightblue
<a id='L335' name='L335'></a> keyword whole PARQUET brightblue
<a id='L336' name='L336'></a> keyword whole AVRO brightblue
<a id='L337' name='L337'></a>
<a id='L338' name='L338'></a># Comments
<a id='L339' name='L339'></a> keyword /\* brown
<a id='L340' name='L340'></a> keyword \*/ brown
<a id='L341' name='L341'></a> keyword -- brown
<a id='L342' name='L342'></a>
<a id='L343' name='L343'></a># Operators
<a id='L344' name='L344'></a> keyword &gt; brightcyan
<a id='L345' name='L345'></a> keyword &lt; brightcyan
<a id='L346' name='L346'></a> keyword \+ brightcyan
<a id='L347' name='L347'></a> keyword - brightcyan
<a id='L348' name='L348'></a> keyword \* brightcyan
<a id='L349' name='L349'></a> keyword / brightcyan
<a id='L350' name='L350'></a> keyword % brightcyan
<a id='L351' name='L351'></a> keyword = brightcyan
<a id='L352' name='L352'></a> keyword ( brightcyan
<a id='L353' name='L353'></a> keyword ) brightcyan
<a id='L354' name='L354'></a> keyword , brightcyan
<a id='L355' name='L355'></a> keyword ; brightcyan
<a id='L356' name='L356'></a> keyword . white
<a id='L357' name='L357'></a> keyword \| white
<a id='L358' name='L358'></a> keyword != white
<a id='L359' name='L359'></a> keyword \^ white
<a id='L360' name='L360'></a> keyword \~ white
<a id='L361' name='L361'></a> keyword whole DIV white
<a id='L362' name='L362'></a> keyword [ brightcyan
<a id='L363' name='L363'></a> keyword ] brightcyan
<a id='L364' name='L364'></a> keyword { brightcyan
<a id='L365' name='L365'></a> keyword } brightcyan
<a id='L366' name='L366'></a> keyword : white
<a id='L367' name='L367'></a> keyword &amp; white
<a id='L368' name='L368'></a> keyword ? white
<a id='L369' name='L369'></a>
<a id='L370' name='L370'></a># Mathematical Functions
<a id='L371' name='L371'></a> keyword whole round yellow
<a id='L372' name='L372'></a> keyword whole bround yellow
<a id='L373' name='L373'></a> keyword whole floor yellow
<a id='L374' name='L374'></a> keyword whole ceil yellow
<a id='L375' name='L375'></a> keyword whole rand yellow
<a id='L376' name='L376'></a> keyword whole exp yellow
<a id='L377' name='L377'></a> keyword whole ln yellow
<a id='L378' name='L378'></a> keyword whole log10 yellow
<a id='L379' name='L379'></a> keyword whole log2 yellow
<a id='L380' name='L380'></a> keyword whole log yellow
<a id='L381' name='L381'></a> keyword whole pow yellow
<a id='L382' name='L382'></a> keyword whole sqrt yellow
<a id='L383' name='L383'></a> keyword whole bin yellow
<a id='L384' name='L384'></a> keyword whole hex yellow
<a id='L385' name='L385'></a> keyword whole unhex yellow
<a id='L386' name='L386'></a> keyword whole conv yellow
<a id='L387' name='L387'></a> keyword whole abs yellow
<a id='L388' name='L388'></a> keyword whole pmod yellow
<a id='L389' name='L389'></a> keyword whole sin yellow
<a id='L390' name='L390'></a> keyword whole asin yellow
<a id='L391' name='L391'></a> keyword whole cos yellow
<a id='L392' name='L392'></a> keyword whole acos yellow
<a id='L393' name='L393'></a> keyword whole tan yellow
<a id='L394' name='L394'></a> keyword whole atan yellow
<a id='L395' name='L395'></a> keyword whole degrees yellow
<a id='L396' name='L396'></a> keyword whole radians yellow
<a id='L397' name='L397'></a> keyword whole positive yellow
<a id='L398' name='L398'></a> keyword whole negative yellow
<a id='L399' name='L399'></a> keyword whole sign yellow
<a id='L400' name='L400'></a> keyword whole e() yellow
<a id='L401' name='L401'></a> keyword whole pi() yellow
<a id='L402' name='L402'></a> keyword whole factorial yellow
<a id='L403' name='L403'></a> keyword whole cbrt yellow
<a id='L404' name='L404'></a> keyword whole shiftleft yellow
<a id='L405' name='L405'></a> keyword whole shiftright yellow
<a id='L406' name='L406'></a> keyword whole shiftrightunsigned yellow
<a id='L407' name='L407'></a> keyword whole greatest yellow
<a id='L408' name='L408'></a> keyword whole least yellow
<a id='L409' name='L409'></a> keyword whole width_bucket yellow
<a id='L410' name='L410'></a>
<a id='L411' name='L411'></a># Collection Functions
<a id='L412' name='L412'></a> keyword whole size yellow
<a id='L413' name='L413'></a> keyword whole map_keys yellow
<a id='L414' name='L414'></a> keyword whole map_values yellow
<a id='L415' name='L415'></a> keyword whole array_contains yellow
<a id='L416' name='L416'></a> keyword whole sort_array yellow
<a id='L417' name='L417'></a>
<a id='L418' name='L418'></a># Type Conversion
<a id='L419' name='L419'></a># binary # keyword
<a id='L420' name='L420'></a># cast # keyword
<a id='L421' name='L421'></a>
<a id='L422' name='L422'></a># Date Functions
<a id='L423' name='L423'></a> keyword whole from_unixtime yellow
<a id='L424' name='L424'></a> keyword whole unix_timestamp yellow
<a id='L425' name='L425'></a> keyword whole to_date yellow
<a id='L426' name='L426'></a> keyword whole year yellow
<a id='L427' name='L427'></a> keyword whole quarter yellow
<a id='L428' name='L428'></a> keyword whole month yellow
<a id='L429' name='L429'></a> keyword whole day yellow
<a id='L430' name='L430'></a> keyword whole hour yellow
<a id='L431' name='L431'></a> keyword whole minute yellow
<a id='L432' name='L432'></a> keyword whole second yellow
<a id='L433' name='L433'></a> keyword whole weekofyear yellow
<a id='L434' name='L434'></a> keyword whole extract yellow
<a id='L435' name='L435'></a> keyword whole datediff yellow
<a id='L436' name='L436'></a> keyword whole date_add yellow
<a id='L437' name='L437'></a> keyword whole date_sub yellow
<a id='L438' name='L438'></a> keyword whole from_utc_timestamp yellow
<a id='L439' name='L439'></a> keyword whole to_utc_timestamp yellow
<a id='L440' name='L440'></a> keyword whole current_date yellow
<a id='L441' name='L441'></a> keyword whole add_months yellow
<a id='L442' name='L442'></a> keyword whole last_day yellow
<a id='L443' name='L443'></a> keyword whole next_day yellow
<a id='L444' name='L444'></a> keyword whole trunc yellow
<a id='L445' name='L445'></a> keyword whole months_between yellow
<a id='L446' name='L446'></a> keyword whole date_format yellow
<a id='L447' name='L447'></a>
<a id='L448' name='L448'></a># Conditional Functions
<a id='L449' name='L449'></a> keyword whole if yellow
<a id='L450' name='L450'></a> keyword whole isnull yellow
<a id='L451' name='L451'></a> keyword whole isnotnull yellow
<a id='L452' name='L452'></a> keyword whole coalesce yellow
<a id='L453' name='L453'></a> keyword whole nullif yellow
<a id='L454' name='L454'></a> keyword whole assert_true yellow
<a id='L455' name='L455'></a>
<a id='L456' name='L456'></a># String Functions
<a id='L457' name='L457'></a> keyword whole ascii yellow
<a id='L458' name='L458'></a> keyword whole base64 yellow
<a id='L459' name='L459'></a> keyword whole character_length yellow
<a id='L460' name='L460'></a> keyword whole chr yellow
<a id='L461' name='L461'></a> keyword whole concat yellow
<a id='L462' name='L462'></a> keyword whole context_ngrams yellow
<a id='L463' name='L463'></a> keyword whole concat_ws yellow
<a id='L464' name='L464'></a> keyword whole decode yellow
<a id='L465' name='L465'></a> keyword whole elt yellow
<a id='L466' name='L466'></a> keyword whole encode yellow
<a id='L467' name='L467'></a> keyword whole field yellow
<a id='L468' name='L468'></a> keyword whole find_in_set yellow
<a id='L469' name='L469'></a> keyword whole format_number yellow
<a id='L470' name='L470'></a> keyword whole get_json_object yellow
<a id='L471' name='L471'></a> keyword whole in_file yellow
<a id='L472' name='L472'></a> keyword whole instr yellow
<a id='L473' name='L473'></a> keyword whole length yellow
<a id='L474' name='L474'></a> keyword whole locate yellow
<a id='L475' name='L475'></a> keyword whole lower yellow
<a id='L476' name='L476'></a> keyword whole lpad yellow
<a id='L477' name='L477'></a> keyword whole ltrim yellow
<a id='L478' name='L478'></a> keyword whole ngrams yellow
<a id='L479' name='L479'></a> keyword whole octet_length yellow
<a id='L480' name='L480'></a> keyword whole parse_url yellow
<a id='L481' name='L481'></a> keyword whole printf yellow
<a id='L482' name='L482'></a> keyword whole regexp_extract yellow
<a id='L483' name='L483'></a> keyword whole regexp_replace yellow
<a id='L484' name='L484'></a> keyword whole repeat yellow
<a id='L485' name='L485'></a> keyword whole replace yellow
<a id='L486' name='L486'></a> keyword whole reverse yellow
<a id='L487' name='L487'></a> keyword whole rpad yellow
<a id='L488' name='L488'></a> keyword whole rtrim yellow
<a id='L489' name='L489'></a> keyword whole sentences yellow
<a id='L490' name='L490'></a> keyword whole space yellow
<a id='L491' name='L491'></a> keyword whole split yellow
<a id='L492' name='L492'></a> keyword whole str_to_map yellow
<a id='L493' name='L493'></a> keyword whole substr yellow
<a id='L494' name='L494'></a> keyword whole substr_index yellow
<a id='L495' name='L495'></a> keyword whole translate yellow
<a id='L496' name='L496'></a> keyword whole trim yellow
<a id='L497' name='L497'></a> keyword whole unbase64 yellow
<a id='L498' name='L498'></a> keyword whole upper yellow
<a id='L499' name='L499'></a> keyword whole initcap yellow
<a id='L500' name='L500'></a> keyword whole levenshtein yellow
<a id='L501' name='L501'></a> keyword whole soundex yellow
<a id='L502' name='L502'></a>
<a id='L503' name='L503'></a># Data Masking Functions
<a id='L504' name='L504'></a> keyword whole mask yellow
<a id='L505' name='L505'></a> keyword whole mask_first_n yellow
<a id='L506' name='L506'></a> keyword whole mask_last_n yellow
<a id='L507' name='L507'></a> keyword whole mask_show_first_n yellow
<a id='L508' name='L508'></a> keyword whole mask_show_last_n yellow
<a id='L509' name='L509'></a> keyword whole mask_hash yellow
<a id='L510' name='L510'></a>
<a id='L511' name='L511'></a># Misc. Functions
<a id='L512' name='L512'></a> keyword whole java_method yellow
<a id='L513' name='L513'></a> keyword whole reflect yellow
<a id='L514' name='L514'></a> keyword whole hash yellow
<a id='L515' name='L515'></a> keyword whole current_user yellow
<a id='L516' name='L516'></a> keyword whole logged_user yellow
<a id='L517' name='L517'></a> keyword whole md5 yellow
<a id='L518' name='L518'></a> keyword whole sha1 yellow
<a id='L519' name='L519'></a> keyword whole sha yellow
<a id='L520' name='L520'></a> keyword whole crc32 yellow
<a id='L521' name='L521'></a> keyword whole sha2 yellow
<a id='L522' name='L522'></a> keyword whole aes_encrypt yellow
<a id='L523' name='L523'></a> keyword whole aes_decrypt yellow
<a id='L524' name='L524'></a> keyword whole version yellow
<a id='L525' name='L525'></a>
<a id='L526' name='L526'></a># xpath
<a id='L527' name='L527'></a> keyword whole xpath yellow
<a id='L528' name='L528'></a> keyword whole xpath_short yellow
<a id='L529' name='L529'></a> keyword whole xpath_int yellow
<a id='L530' name='L530'></a> keyword whole xpath_long yellow
<a id='L531' name='L531'></a> keyword whole xpath_float yellow
<a id='L532' name='L532'></a> keyword whole xpath_double yellow
<a id='L533' name='L533'></a> keyword whole xpath_number yellow
<a id='L534' name='L534'></a> keyword whole xpath_string yellow
<a id='L535' name='L535'></a>
<a id='L536' name='L536'></a># Aggregate Functions
<a id='L537' name='L537'></a> keyword whole count yellow
<a id='L538' name='L538'></a> keyword whole sum yellow
<a id='L539' name='L539'></a> keyword whole avg yellow
<a id='L540' name='L540'></a> keyword whole min yellow
<a id='L541' name='L541'></a> keyword whole max yellow
<a id='L542' name='L542'></a> keyword whole variance yellow
<a id='L543' name='L543'></a> keyword whole var_samp yellow
<a id='L544' name='L544'></a> keyword whole stddev_pop yellow
<a id='L545' name='L545'></a> keyword whole stddev_samp yellow
<a id='L546' name='L546'></a> keyword whole covar_pop yellow
<a id='L547' name='L547'></a> keyword whole covar_samp yellow
<a id='L548' name='L548'></a> keyword whole corr yellow
<a id='L549' name='L549'></a> keyword whole percentile yellow
<a id='L550' name='L550'></a> keyword whole regr_avgx yellow
<a id='L551' name='L551'></a> keyword whole regr_avgy yellow
<a id='L552' name='L552'></a> keyword whole regr_count yellow
<a id='L553' name='L553'></a> keyword whole regr_intercept yellow
<a id='L554' name='L554'></a> keyword whole regr_r2 yellow
<a id='L555' name='L555'></a> keyword whole regr_slope yellow
<a id='L556' name='L556'></a> keyword whole regr_sxx yellow
<a id='L557' name='L557'></a> keyword whole regr_sxy yellow
<a id='L558' name='L558'></a> keyword whole regr_syy yellow
<a id='L559' name='L559'></a> keyword whole histogram_numeric yellow
<a id='L560' name='L560'></a> keyword whole collect_set yellow
<a id='L561' name='L561'></a> keyword whole collect_list yellow
<a id='L562' name='L562'></a> keyword whole ntile yellow
<a id='L563' name='L563'></a>
<a id='L564' name='L564'></a># Table-Generating Functions
<a id='L565' name='L565'></a> keyword whole explode yellow
<a id='L566' name='L566'></a> keyword whole posexplode yellow
<a id='L567' name='L567'></a> keyword whole inline yellow
<a id='L568' name='L568'></a> keyword whole stack yellow
<a id='L569' name='L569'></a> keyword whole json_tuple yellow
<a id='L570' name='L570'></a> keyword whole parse_url yellow
<a id='L571' name='L571'></a>
<a id='L572' name='L572'></a># Window Functions
<a id='L573' name='L573'></a> keyword whole lead yellow
<a id='L574' name='L574'></a> keyword whole lag yellow
<a id='L575' name='L575'></a> keyword whole first_value yellow
<a id='L576' name='L576'></a> keyword whole last_value yellow
<a id='L577' name='L577'></a> keyword whole rank yellow
<a id='L578' name='L578'></a> keyword whole row_number yellow
<a id='L579' name='L579'></a> keyword whole dense_rank yellow
<a id='L580' name='L580'></a> keyword whole cume_dist yellow
<a id='L581' name='L581'></a> keyword whole percent_rank yellow
<a id='L582' name='L582'></a> keyword whole ntile yellow
<a id='L583' name='L583'></a>
<a id='L584' name='L584'></a># Variables
<a id='L585' name='L585'></a> # oozie variables
<a id='L586' name='L586'></a> keyword whole ${+} brightgreen
<a id='L587' name='L587'></a> # hive variables
<a id='L588' name='L588'></a> keyword whole ${hiveconf:+} magenta
<a id='L589' name='L589'></a>
<a id='L590' name='L590'></a>
<a id='L591' name='L591'></a># Hive options
<a id='L592' name='L592'></a> keyword wholeright hive.+.+.+ red
<a id='L593' name='L593'></a> keyword wholeright tez.+.+ red
<a id='L594' name='L594'></a> keyword wholeright mapreduce.+.+ red
<a id='L595' name='L595'></a>
<a id='L596' name='L596'></a># Literals
<a id='L597' name='L597'></a> # float
<a id='L598' name='L598'></a> keyword whole \[0123456789\]\{.\}\[0123456789\] brightmagenta
<a id='L599' name='L599'></a> # float e notation
<a id='L600' name='L600'></a> keyword whole \[0123456789\]\[.\]\[0123456789\]\{e\}\[\+-\]\{0123456789\}\[0123456789\] brightmagenta
<a id='L601' name='L601'></a>
<a id='L602' name='L602'></a> # tinyint
<a id='L603' name='L603'></a> keyword whole \{0123456789\}\[0123456789\]Y magenta
<a id='L604' name='L604'></a> # smallint
<a id='L605' name='L605'></a> keyword whole \{0123456789\}\[0123456789\]S magenta
<a id='L606' name='L606'></a> # bigint
<a id='L607' name='L607'></a> keyword whole \{0123456789\}\[0123456789\]L magenta
<a id='L608' name='L608'></a> # int
<a id='L609' name='L609'></a> keyword whole \{0123456789\}\[0123456789\] brightmagenta
<a id='L610' name='L610'></a> # big decimal
<a id='L611' name='L611'></a> keyword whole \{0123456789\}\[0123456789\]BD magenta
<a id='L612' name='L612'></a>
<a id='L613' name='L613'></a>context exclusive -- \n brown
<a id='L614' name='L614'></a> spellcheck
<a id='L615' name='L615'></a>
<a id='L616' name='L616'></a>context exclusive /\* \*/ brown
<a id='L617' name='L617'></a> spellcheck
<a id='L618' name='L618'></a>
<a id='L619' name='L619'></a>context ' ' green
<a id='L620' name='L620'></a> keyword \\' brightgreen
<a id='L621' name='L621'></a> # oozie variables
<a id='L622' name='L622'></a> keyword whole ${+} brightgreen
<a id='L623' name='L623'></a> # hive variables
<a id='L624' name='L624'></a> keyword whole ${hiveconf:+} magenta
<a id='L625' name='L625'></a>
<a id='L626' name='L626'></a>context " " red
<a id='L627' name='L627'></a> keyword \\" brightred
</pre>
<hr />
<a id='BOTTOM' name='BOTTOM'></a>
<em class='comment'>/* <img class='icon' src='../icons/n_left.png' alt='[previous]' /><img class='icon' src='../icons/n_right.png' alt='[next]' /><img class='icon' src='../icons/n_first.png' alt='[first]' /><img class='icon' src='../icons/n_last.png' alt='[last]' /><a href='#TOP'><img class='icon' src='../icons/top.png' alt='[top]' /></a><img class='icon' src='../icons/n_bottom.png' alt='[bottom]' /><a href='../mains.html'><img class='icon' src='../icons/index.png' alt='[index]' /></a><a href='../help.html'><img class='icon' src='../icons/help.png' alt='[help]' /></a>&nbsp;<input type='text' readonly onfocus='this.select();' value='+627 misc/syntax/hive.syntax' /> */</em>
</body>
</html>
Reference in New Issue View Git Blame Copy Permalink