Modifier and Type | Class and Description |
---|---|
class |
GenericUDFAdd10
GenericUDFAbs.
|
class |
GenericUDFDBOutput
GenericUDFDBOutput is designed to output data directly from Hive to a JDBC
datastore.
|
Modifier and Type | Class and Description |
---|---|
class |
UDAFExampleAvg
This is a simple UDAF that calculates average.
|
class |
UDAFExampleGroupConcat
This is a simple UDAF that concatenates all arguments from different rows
into a single string.
|
class |
UDAFExampleMax |
class |
UDAFExampleMaxN
Returns the max N double values.
|
class |
UDAFExampleMin |
class |
UDAFExampleMinN
Returns the min N double values.
|
Modifier and Type | Class and Description |
---|---|
class |
UDFRowSequence
UDFRowSequence.
|
Modifier and Type | Class and Description |
---|---|
class |
UDFExampleAdd
UDFExampleAdd.
|
class |
UDFExampleArraySum
UDFExampleArraySum.
|
class |
UDFExampleFormat
UDFExampleFormat.
|
class |
UDFExampleMapConcat
UDFExampleMapConcat.
|
class |
UDFExampleStructPrint
UDFExampleStructPrint.
|
Modifier and Type | Class and Description |
---|---|
class |
GenericUDTFCount2
GenericUDTFCount2 outputs the number of rows seen, twice.
|
class |
GenericUDTFExplode2
GenericUDTFExplode2.
|
Modifier and Type | Class and Description |
---|---|
class |
VectorUDAFAvgDecimal
Generated from template VectorUDAFAvg.txt.
|
class |
VectorUDAFAvgTimestamp
Generated from template VectorUDAFAvg.txt.
|
class |
VectorUDAFCount
VectorUDAFCountLong.
|
class |
VectorUDAFCountMerge
VectorUDAFCountMerge.
|
class |
VectorUDAFCountStar
VectorUDAFCountStar.
|
class |
VectorUDAFStdPopTimestamp
VectorUDAFStdPopTimestamp.
|
class |
VectorUDAFStdSampTimestamp
VectorUDAFStdSampTimestamp.
|
class |
VectorUDAFSumDecimal
VectorUDAFSumDecimal.
|
class |
VectorUDAFVarPopTimestamp
VectorUDAFVarPopTimestamp.
|
class |
VectorUDAFVarSampTimestamp
VectorUDAFVarSampTimestamp.
|
Modifier and Type | Class and Description |
---|---|
class |
VectorUDAFAvgDouble
Generated from template VectorUDAFAvg.txt.
|
class |
VectorUDAFAvgLong
Generated from template VectorUDAFAvg.txt.
|
class |
VectorUDAFMaxDecimal
VectorUDAFMaxDecimal.
|
class |
VectorUDAFMaxDouble
VectorUDAFMaxDouble.
|
class |
VectorUDAFMaxIntervalDayTime
VectorUDAFMaxIntervalDayTime.
|
class |
VectorUDAFMaxLong
VectorUDAFMaxLong.
|
class |
VectorUDAFMaxString
VectorUDAFMaxString.
|
class |
VectorUDAFMaxTimestamp
VectorUDAFMaxTimestamp.
|
class |
VectorUDAFMinDecimal
VectorUDAFMinDecimal.
|
class |
VectorUDAFMinDouble
VectorUDAFMinDouble.
|
class |
VectorUDAFMinIntervalDayTime
VectorUDAFMinIntervalDayTime.
|
class |
VectorUDAFMinLong
VectorUDAFMinLong.
|
class |
VectorUDAFMinString
VectorUDAFMinString.
|
class |
VectorUDAFMinTimestamp
VectorUDAFMinTimestamp.
|
class |
VectorUDAFStdPopDecimal
VectorUDAFStdPopDecimal.
|
class |
VectorUDAFStdPopDouble
VectorUDAFStdPopDouble.
|
class |
VectorUDAFStdPopLong
VectorUDAFStdPopLong.
|
class |
VectorUDAFStdSampDecimal
VectorUDAFStdSampDecimal.
|
class |
VectorUDAFStdSampDouble
VectorUDAFStdSampDouble.
|
class |
VectorUDAFStdSampLong
VectorUDAFStdSampLong.
|
class |
VectorUDAFSumDouble
VectorUDAFSumDouble.
|
class |
VectorUDAFSumLong
VectorUDAFSumLong.
|
class |
VectorUDAFVarPopDecimal
VectorUDAFVarPopDecimal.
|
class |
VectorUDAFVarPopDouble
VectorUDAFVarPopDouble.
|
class |
VectorUDAFVarPopLong
VectorUDAFVarPopLong.
|
class |
VectorUDAFVarSampDecimal
VectorUDAFVarSampDecimal.
|
class |
VectorUDAFVarSampDouble
VectorUDAFVarSampDouble.
|
class |
VectorUDAFVarSampLong
VectorUDAFVarSampLong.
|
Modifier and Type | Class and Description |
---|---|
class |
UDAFPercentile
UDAF for calculating the percentile values.
|
class |
UDFAcos
UDFAcos.
|
class |
UDFAscii
UDFAscii.
|
class |
UDFAsin
UDFAsin.
|
class |
UDFAtan |
class |
UDFBase64 |
class |
UDFBin
UDFBin.
|
class |
UDFChr
UDFChr converts an integer into its ASCII equivalent.
|
class |
UDFConv
UDFConv.
|
class |
UDFCos
UDFCos.
|
class |
UDFCrc32
UDFCrc32.
|
class |
UDFDateFloorDay
UDFDateFloorDay.
|
class |
UDFDateFloorHour
UDFDateFloorHour.
|
class |
UDFDateFloorMinute
UDFDateFloorMinute.
|
class |
UDFDateFloorMonth
UDFDateFloorMonth.
|
class |
UDFDateFloorQuarter
UDFDateFloorQuarter.
|
class |
UDFDateFloorSecond
UDFDateFloorSecond.
|
class |
UDFDateFloorWeek
UDFDateFloorWeek.
|
class |
UDFDateFloorYear
UDFDateFloorYear.
|
class |
UDFDayOfMonth
UDFDayOfMonth.
|
class |
UDFDayOfWeek
UDFDayOfWeek.
|
class |
UDFDegrees |
class |
UDFE |
class |
UDFExp
UDFExp.
|
class |
UDFFindInSet
UDFFindInSet.
|
class |
UDFFromUnixTime
UDFFromUnixTime.
|
class |
UDFHex
UDFHex.
|
class |
UDFHour
UDFHour.
|
class |
UDFJson
UDFJson.
|
class |
UDFLike
UDFLike.
|
class |
UDFLn
UDFLn.
|
class |
UDFLog
UDFLog.
|
class |
UDFLog10
UDFLog10.
|
class |
UDFLog2
UDFLog2.
|
class |
UDFMd5
UDFMd5.
|
class |
UDFMinute
UDFMinute.
|
class |
UDFMonth
UDFMonth.
|
class |
UDFOPBitAnd
UDFOPBitAnd.
|
class |
UDFOPBitNot
UDFOPBitNot.
|
class |
UDFOPBitOr
UDFOPBitOr.
|
class |
UDFOPBitShiftLeft
UDFOPBitLeftShift.
|
class |
UDFOPBitShiftRight
UDFOPBitRightShift.
|
class |
UDFOPBitShiftRightUnsigned
UDFOPBitUnsignedRightShift.
|
class |
UDFOPBitXor
UDFOPBitXor.
|
class |
UDFOPLongDivide
UDFOPLongDivide.
|
class |
UDFParseUrl
UDF to extract specfic parts from URL For example,
parse_url('http://facebook.com/path/p1.php?query=1', 'HOST') will return
'facebook.com' For example,
parse_url('http://facebook.com/path/p1.php?query=1', 'PATH') will return
'/path/p1.php' parse_url('http://facebook.com/path/p1.php?query=1', 'QUERY')
will return 'query=1'
parse_url('http://facebook.com/path/p1.php?query=1#Ref', 'REF') will return
'Ref' parse_url('http://facebook.com/path/p1.php?query=1#Ref', 'PROTOCOL')
will return 'http' Possible values are
HOST,PATH,QUERY,REF,PROTOCOL,AUTHORITY,FILE,USERINFO Also you can get a value
of particular key in QUERY, using syntax QUERY:
|
class |
UDFPI |
class |
UDFRadians |
class |
UDFRand
UDFRand.
|
class |
UDFRegExpExtract
UDF to extract a specific group identified by a java regex.
|
class |
UDFRegExpReplace
UDFRegExpReplace.
|
class |
UDFRepeat
UDFRepeat.
|
class |
UDFReplace
UDFReplace replaces all substrings that are matched with a replacement substring.
|
class |
UDFReverse
UDFReverse.
|
class |
UDFSecond
UDFSecond.
|
class |
UDFSha1
UDFSha.
|
class |
UDFSign |
class |
UDFSin
UDFSin.
|
class |
UDFSpace
UDFSpace.
|
class |
UDFSqrt
Implementation of the SQRT UDF found in many databases.
|
class |
UDFSubstr
UDFSubstr.
|
class |
UDFTan |
class |
UDFUnbase64 |
class |
UDFUnhex
UDFUnhex.
|
class |
UDFUUID
UDFUUID.
|
class |
UDFVersion
UDFVersion
|
class |
UDFWeekOfYear
UDFWeekOfYear.
|
class |
UDFYear
UDFYear.
|
Modifier and Type | Class and Description |
---|---|
class |
GenericUDAFAverage
GenericUDAFAverage.
|
static class |
GenericUDAFBinarySetFunctions.RegrAvgX |
static class |
GenericUDAFBinarySetFunctions.RegrAvgY |
static class |
GenericUDAFBinarySetFunctions.RegrCount |
static class |
GenericUDAFBinarySetFunctions.RegrIntercept |
static class |
GenericUDAFBinarySetFunctions.RegrR2 |
static class |
GenericUDAFBinarySetFunctions.RegrSlope |
static class |
GenericUDAFBinarySetFunctions.RegrSXX |
static class |
GenericUDAFBinarySetFunctions.RegrSXY |
static class |
GenericUDAFBinarySetFunctions.RegrSYY |
class |
GenericUDAFCollectList |
class |
GenericUDAFCollectSet
GenericUDAFCollectSet
|
class |
GenericUDAFComputeStats
GenericUDAFComputeStats
|
class |
GenericUDAFContextNGrams
Estimates the top-k contextual n-grams in arbitrary sequential data using a heuristic.
|
class |
GenericUDAFCorrelation
Compute the Pearson correlation coefficient corr(x, y), using the following
stable one-pass method, based on:
"Formulas for Robust, One-Pass Parallel Computation of Covariances and
Arbitrary-Order Statistical Moments", Philippe Pebay, Sandia Labs
and "The Art of Computer Programming, volume 2: Seminumerical Algorithms",
Donald Knuth.
|
class |
GenericUDAFCount
This class implements the COUNT aggregation function as in SQL.
|
class |
GenericUDAFCovariance
Compute the covariance covar_pop(x, y), using the following one-pass method
(ref.
|
class |
GenericUDAFCovarianceSample
Compute the sample covariance by extending GenericUDAFCovariance and overriding
the terminate() method of the evaluator.
|
class |
GenericUDAFEWAHBitmap
GenericUDAFEWAHBitmap.
|
class |
GenericUDAFHistogramNumeric
Computes an approximate histogram of a numerical column using a user-specified number of bins.
|
class |
GenericUDAFMax |
class |
GenericUDAFMin |
class |
GenericUDAFnGrams
Estimates the top-k n-grams in arbitrary sequential data using a heuristic.
|
class |
GenericUDAFPercentileApprox
Computes an approximate percentile (quantile) from an approximate histogram, for very
large numbers of rows where the regular percentile() UDAF might run out of memory.
|
class |
GenericUDAFStd
Compute the standard deviation by extending GenericUDAFVariance and
overriding the terminate() method of the evaluator.
|
class |
GenericUDAFStdSample
Compute the sample standard deviation by extending GenericUDAFVariance and
overriding the terminate() method of the evaluator.
|
class |
GenericUDAFSum
GenericUDAFSum.
|
class |
GenericUDAFSumEmptyIsZero |
class |
GenericUDAFVariance
Compute the variance.
|
class |
GenericUDAFVarianceSample
Compute the sample variance by extending GenericUDAFVariance and overriding
the terminate() method of the evaluator.
|
class |
GenericUDFAbs
GenericUDFAbs.
|
class |
GenericUDFAddMonths
GenericUDFAddMonths.
|
class |
GenericUDFAesDecrypt
GenericUDFAesDecrypt.
|
class |
GenericUDFAesEncrypt
GenericUDFAesEncrypt.
|
class |
GenericUDFArray
GenericUDFArray.
|
class |
GenericUDFArrayContains
GenericUDFArrayContains.
|
class |
GenericUDFAssertTrue
GenericUDFAssertTrue
|
class |
GenericUDFBaseCompare
GenericUDF Base Class for operations.
|
class |
GenericUDFBaseNumeric
GenericUDF Base Class for operations.
|
class |
GenericUDFBetween |
class |
GenericUDFBRound |
class |
GenericUDFCardinalityViolation
GenericUDFArray.
|
class |
GenericUDFCase
GenericUDF Class for SQL construct "CASE a WHEN b THEN c [ELSE f] END".
|
class |
GenericUDFCbrt
GenericUDFCbrt.
|
class |
GenericUDFCeil |
class |
GenericUDFCharacterLength |
class |
GenericUDFCoalesce
GenericUDF Class for SQL construct "COALESCE(a, b, c)".
|
class |
GenericUDFConcat
GenericUDFConcat.
|
class |
GenericUDFConcatWS
Generic UDF for string function
CONCAT_WS(sep, [string | array(string)]+) |
class |
GenericUDFCurrentDate |
class |
GenericUDFCurrentTimestamp |
class |
GenericUDFCurrentUser |
class |
GenericUDFDate
UDFDate.
|
class |
GenericUDFDateAdd
UDFDateAdd.
|
class |
GenericUDFDateDiff
UDFDateDiff.
|
class |
GenericUDFDateFormat
GenericUDFDateFormat.
|
class |
GenericUDFDateSub
UDFDateSub.
|
class |
GenericUDFDecode |
class |
GenericUDFElt
Generic UDF for string function
ELT(N,str1,str2,str3,...) . |
class |
GenericUDFEncode |
class |
GenericUDFEWAHBitmapAnd
GenericEWAHUDFBitmapAnd.
|
class |
GenericUDFEWAHBitmapEmpty |
class |
GenericUDFEWAHBitmapOr
GenericUDFEWAHBitmapOr.
|
class |
GenericUDFExtractUnion |
class |
GenericUDFFactorial
GenericUDFFactorial
|
class |
GenericUDFField
GenericUDFField.
|
class |
GenericUDFFloor |
class |
GenericUDFFormatNumber
Generic UDF for format_number function
FORMAT_NUMBER(X, D or F) . |
class |
GenericUDFFromUtcTimestamp |
class |
GenericUDFGreatest
GenericUDF Class for SQL construct "greatest(v1, v2, ..
|
class |
GenericUDFGrouping
UDF grouping
|
class |
GenericUDFHash
GenericUDF Class for computing hash values.
|
class |
GenericUDFIf
IF(expr1,expr2,expr3)
If expr1 is TRUE (expr1 <> 0 and expr1 <> NULL) then IF() returns expr2; otherwise it returns expr3. |
class |
GenericUDFIn
GenericUDFIn
Example usage:
SELECT key FROM src WHERE key IN ("238", "1");
From MySQL page on IN(): To comply with the SQL standard, IN returns NULL
not only if the expression on the left hand side is NULL, but also if no
match is found in the list and one of the expressions in the list is NULL.
|
class |
GenericUDFIndex
GenericUDFIndex.
|
class |
GenericUDFInFile
IN_FILE(str, filename) returns true if 'str' appears in the file specified
by 'filename'.
|
class |
GenericUDFInitCap
UDFInitCap.
|
class |
GenericUDFInstr
Generic UDF for string function
INSTR(str,substr) . |
class |
GenericUDFInternalInterval
GenericUDF Class for support of "INTERVAL (expression) (DAY|YEAR|...)".
|
class |
GenericUDFLag |
class |
GenericUDFLastDay
GenericUDFLastDay.
|
class |
GenericUDFLead |
class |
GenericUDFLeast
GenericUDF Class for SQL construct "least(v1, v2, ..
|
class |
GenericUDFLength
GenericUDFLength.
|
class |
GenericUDFLevenshtein
GenericUDFLevenshtein.
|
class |
GenericUDFLocate
Generic UDF for string function
LOCATE(substr, str) ,
LOCATE(substr, str, start) . |
class |
GenericUDFLoggedInUser |
class |
GenericUDFLower
UDFLower.
|
class |
GenericUDFLpad
UDFLpad.
|
class |
GenericUDFLTrim
UDFLTrim.
|
class |
GenericUDFMap
GenericUDFMap.
|
class |
GenericUDFMapKeys
GenericUDFMapKeys.
|
class |
GenericUDFMapValues
GenericUDFMapValues.
|
class |
GenericUDFMask |
class |
GenericUDFMaskFirstN |
class |
GenericUDFMaskHash |
class |
GenericUDFMaskLastN |
class |
GenericUDFMaskShowFirstN |
class |
GenericUDFMaskShowLastN |
class |
GenericUDFMonthsBetween
UDFMonthsBetween.
|
class |
GenericUDFNamedStruct |
class |
GenericUDFNextDay
GenericUDFNextDay.
|
class |
GenericUDFNullif
GenericUDF Class for SQL construct "nullif(a,b)".
|
class |
GenericUDFNvl |
class |
GenericUDFOctetLength |
class |
GenericUDFOPAnd
GenericUDF Class for computing and.
|
class |
GenericUDFOPDivide
Note that in SQL, the return type of divide is not necessarily the same
as the parameters.
|
class |
GenericUDFOPDTIMinus |
class |
GenericUDFOPDTIPlus |
class |
GenericUDFOPEqual
GenericUDF Class for operation EQUAL.
|
class |
GenericUDFOPEqualNS |
class |
GenericUDFOPEqualOrGreaterThan
GenericUDF Class for operation EqualOrGreaterThan.
|
class |
GenericUDFOPEqualOrLessThan
GenericUDF Class for operation EqualOrLessThan.
|
class |
GenericUDFOPGreaterThan
GenericUDF Class for operation GreaterThan.
|
class |
GenericUDFOPLessThan
GenericUDF Class for operation LessThan.
|
class |
GenericUDFOPMinus |
class |
GenericUDFOPMod |
class |
GenericUDFOPMultiply |
class |
GenericUDFOPNegative |
class |
GenericUDFOPNot
GenericUDFOPNot.
|
class |
GenericUDFOPNotEqual
GenericUDF Class for operation Not EQUAL.
|
class |
GenericUDFOPNotNull
GenericUDFOPNotNull.
|
class |
GenericUDFOPNull
GenericUDFOPNull.
|
class |
GenericUDFOPNumericMinus |
class |
GenericUDFOPNumericPlus
The reason that we list evaluate methods with all numeric types is for both
better performance and type checking (so we know int + int is still an int
instead of a double); otherwise a single method that takes (Number a, Number
b) and use a.doubleValue() == b.doubleValue() is enough.
|
class |
GenericUDFOPOr
GenericUDF Class for computing or.
|
class |
GenericUDFOPPlus
The reason that we list evaluate methods with all numeric types is for both
better performance and type checking (so we know int + int is still an int
instead of a double); otherwise a single method that takes (Number a, Number
b) and use a.doubleValue() == b.doubleValue() is enough.
|
class |
GenericUDFOPPositive |
class |
GenericUDFPosMod
class for computing positive modulo.
|
class |
GenericUDFPower |
class |
GenericUDFPrintf
Generic UDF for printf function
printf(String format, Obj... |
class |
GenericUDFQuarter
GenericUDFQuarter.
|
class |
GenericUDFReflect
A simple generic udf to call java static functions via reflection.
|
class |
GenericUDFReflect2
A simple generic udf to call java functions via reflection.
|
class |
GenericUDFRegExp
UDF to extract a specific group identified by a java regex.
|
class |
GenericUDFRound
Note: rounding function permits rounding off integer digits in decimal numbers, which essentially
downgrades the scale to negative territory.
|
class |
GenericUDFRpad
UDFRpad.
|
class |
GenericUDFRTrim
UDFRTrim.
|
class |
GenericUDFSentences
GenericUDFSentences: splits a natural language chunk of text into sentences and words.
|
class |
GenericUDFSha2
GenericUDFSha2.
|
class |
GenericUDFSize
GenericUDFSize.
|
class |
GenericUDFSortArray
Generic UDF for array sort
SORT_ARRAY(array(obj1, obj2, obj3...)) . |
class |
GenericUDFSortArrayByField
Generic UDF for tuple array sort by desired field[s] with [ordering(ASC or DESC)]
SORT_ARRAY_BY(array(obj1, obj2, obj3...),'f1','f2',..,['ASC','DESC']) . |
class |
GenericUDFSoundex
GenericUDFSoundex.
|
class |
GenericUDFSplit
GenericUDFSplit.
|
class |
GenericUDFSQCountCheck
GenericUDFAbs.
|
class |
GenericUDFStringToMap
GenericUDFStringToMap.
|
class |
GenericUDFStruct |
class |
GenericUDFSubstringIndex
GenericUDFSubstringIndex.
|
class |
GenericUDFTimestamp
GenericUDFTimestamp
Example usage:
...
|
class |
GenericUDFToBinary |
class |
GenericUDFToChar |
class |
GenericUDFToDate
GenericUDFToDate
|
class |
GenericUDFToDecimal |
class |
GenericUDFToIntervalDayTime
GenericUDFIntervalDayTime
Example usage:
...
|
class |
GenericUDFToIntervalYearMonth
GenericUDFIntervalYearMonth
Example usage:
...
|
class |
GenericUDFToUnixTimeStamp
deterministic version of UDFUnixTimeStamp.
|
class |
GenericUDFToUtcTimestamp |
class |
GenericUDFToVarchar |
class |
GenericUDFTranslate
TRANSLATE(string input, string from, string to) is an equivalent function to translate in
PostGresSQL.
|
class |
GenericUDFTrim
UDFTrim.
|
class |
GenericUDFTrunc
GenericUDFTrunc.
|
class |
GenericUDFUnion |
class |
GenericUDFUnixTimeStamp |
class |
GenericUDFUpper
UDFUpper.
|
class |
GenericUDFWhen
GenericUDF Class for SQL construct
"CASE WHEN a THEN b WHEN c THEN d [ELSE f] END".
|
class |
GenericUDTFExplode
GenericUDTFExplode.
|
class |
GenericUDTFGetSplits
GenericUDTFGetSplits.
|
class |
GenericUDTFInline |
class |
GenericUDTFJSONTuple
GenericUDTFJSONTuple: this
|
class |
GenericUDTFParseUrlTuple
GenericUDTFParseUrlTuple: this
|
class |
GenericUDTFPosExplode
PosExplode.
|
class |
GenericUDTFReplicateRows
Takes a row of data and repeats n times.
|
class |
GenericUDTFStack
Takes a row of size k of data and splits it into n rows of data.
|
class |
UDFCurrentDB |
Modifier and Type | Class and Description |
---|---|
class |
GenericUDFXPath |
class |
UDFXPathBoolean |
class |
UDFXPathDouble |
class |
UDFXPathFloat |
class |
UDFXPathInteger |
class |
UDFXPathLong |
class |
UDFXPathShort |
class |
UDFXPathString |
Modifier and Type | Class and Description |
---|---|
class |
Udf |
Copyright © 2021 The Apache Software Foundation. All rights reserved.