Hive是一个基于Hadoop的数据仓库平台。通过hive，我们可以方便地进行ETL的工作。hive定义了一个类似于SQL的查询语言：HQL，能 够将用户编写的QL转化为相应的Mapreduce程序基于Hadoop执行。 Hive是Facebook 2008年8月刚开源的一个数据仓库框架，其系统目标与 Pig 有相似之处，但它有一些Pig目前还不支持的机制，比如：更丰富的类型系统、更类似SQL的查询语言、Table/Partition元数据的持久化等。 Apache Hive 1.2.0 发布，此版本现已提供下载：https://hive.apache.org/downloads.html。 Hive 1.2.0 发行说明请看这里：https://issues.apache.org/jira/secu...on=12329345&styleName=Text&projectId=12310843。 详细更新内容如下： Bug 修复 [HIVE-3454] - Problem with CAST(BIGINT as TIMESTAMP) [HIVE-4625] - HS2 should not attempt to get delegation token from metastore if using embedded metastore [HIVE-5545] - HCatRecord getInteger method returns String when used on Partition columns of type INT [HIVE-5672] - Insert with custom separator not supported for non-local directory [HIVE-6069] - Improve error message in GenericUDFRound [HIVE-6099] - Multi insert does not work properly with distinct count [HIVE-6950] - Parsing Error in GROUPING SETS [HIVE-7351] - ANALYZE TABLE statement fails on postgres metastore [HIVE-7641] - INSERT ... SELECT with no source table leads to NPE [HIVE-8524] - When table is renamed stats are lost as changes are not propagated to metastore tables TAB_COL_STATS and PART_COL_STATS [HIVE-8626] - Extend HDFS super-user checks to dropPartitions [HIVE-8746] - ORC timestamp columns are sensitive to daylight savings time [HIVE-8890] - HiveServer2 dynamic service discovery: use persistent ephemeral nodes curator recipe [HIVE-8915] - Log file explosion due to non-existence of COMPACTION_QUEUE table [HIVE-9002] - union all does not generate correct result for order by and limit [HIVE-9023] - HiveHistoryImpl relies on removed counters to print num rows [HIVE-9073] - NPE when using custom windowing UDAFs [HIVE-9083] - New metastore API to support to purge partition-data directly in dropPartitions(). [HIVE-9086] - Add language support to PURGE data while dropping partitions. [HIVE-9115] - Hive build failure on hadoop-2.7 due to HADOOP-11356 [HIVE-9118] - Support auto-purge for tables, when dropping tables/partitions. [HIVE-9151] - Checking s against null in TezJobMonitor#getNameWithProgress() should be done earlier [HIVE-9228] - Problem with subquery using windowing functions [HIVE-9303] - Parquet files are written with incorrect definition levels [HIVE-9322] - Make null-checks consistent for MapObjectInspector subclasses. [HIVE-9350] - Add ability for HiveAuthorizer implementations to filter out results of 'show tables', 'show databases' [HIVE-9397] - SELECT max(bar) FROM foo is broken after ANALYZE ... FOR COLUMNS [HIVE-9430] - NullPointerException on ALTER TABLE ADD PARTITION if no value given [HIVE-9438] - The standalone-jdbc jar missing some jars [HIVE-9456] - Make Hive support unicode with MSSQL as Metastore backend [HIVE-9468] - Test groupby3_map_skew.q fails due to decimal precision difference [HIVE-9471] - Bad seek in uncompressed ORC, at row-group boundary. [HIVE-9472] - Implement 7 simple UDFs added to Hive [HIVE-9474] - truncate table changes permissions on the target [HIVE-9481] - allow column list specification in INSERT statement [HIVE-9482] - Hive parquet timestamp compatibility [HIVE-9484] - ThriftCLIService#getDelegationToken does case sensitive comparison [HIVE-9486] - Use session classloader instead of application loader [HIVE-9489] - add javadoc for UDFType annotation [HIVE-9496] - Slf4j warning in hive command [HIVE-9507] - Make "LATERAL VIEW inline(expression) mytable" tolerant to nulls [HIVE-9509] - Restore partition spec validation removed by HIVE-9445 [HIVE-9512] - HIVE-9327 causing regression in stats annotation [HIVE-9513] - NULL POINTER EXCEPTION [HIVE-9526] - ClassCastException thrown by HiveStatement [HIVE-9529] - "alter table .. concatenate" under Tez mode should create TezTask [HIVE-9539] - Wrong check of version format in TestWebHCatE2e.getHiveVersion() [HIVE-9553] - Fix log-line in Partition Pruner [HIVE-9555] - assorted ORC refactorings for LLAP on trunk [HIVE-9560] - When hive.stats.collect.rawdatasize=true, 'rawDataSize' for an ORC table will result in value '0' after running 'analyze table TABLE_NAME compute statistics;' [HIVE-9565] - Minor cleanup in TestMetastoreExpr. [HIVE-9567] - JSON SerDe not escaping special chars when writing char/varchar data [HIVE-9580] - Server returns incorrect result from JOIN ON VARCHAR columns [HIVE-9587] - UDF decode should accept STRING_GROUP types for the second parameter [HIVE-9588] - Reimplement HCatClientHMSImpl.dropPartitions() with HMSC.dropPartitions() [HIVE-9592] - fix ArrayIndexOutOfBoundsException in date_add and date_sub initialize [HIVE-9609] - AddPartitionMessage.getPartitions() can return null [HIVE-9612] - Turn off DEBUG logging for Lazy Objects for tests [HIVE-9613] - Left join query plan outputs wrong column when using subquery [HIVE-9617] - UDF from_utc_timestamp throws NPE if the second argument is null [HIVE-9619] - Uninitialized read of numBitVectors in NumDistinctValueEstimator [HIVE-9620] - Cannot retrieve column statistics using HMS API if column name contains uppercase characters [HIVE-9622] - Getting NPE when trying to restart HS2 when metastore is configured to use org.apache.hadoop.hive.thrift.DBTokenStore [HIVE-9623] - NullPointerException in MapJoinOperator.processOp(MapJoinOperator.java:253) for TPC-DS Q75 against un-partitioned schema [HIVE-9624] - NullPointerException in MapJoinOperator.processOp(MapJoinOperator.java:253) for TPC-DS Q75 against un-partitioned schema [HIVE-9628] - HiveMetaStoreClient.dropPartitions(...List<ObjectPair<Integer,byte[]>>...) doesn't take (boolean needResult) [HIVE-9633] - Add HCatClient.dropPartitions() overload to skip deletion of partition-directories. [HIVE-9644] - Fold case & when udfs [HIVE-9645] - Constant folding case NULL equality [HIVE-9647] - Discrepancy in cardinality estimates between partitioned and un-partitioned tables [HIVE-9648] - Null check key provider before doing set [HIVE-9652] - Tez in place updates should detect redirection of STDERR [HIVE-9655] - Dynamic partition table insertion error [HIVE-9665] - Parallel move task optimization causes race condition [HIVE-9667] - Disable ORC bloom filters for ORC v11 output-format [HIVE-9674] - *DropPartitionEvent should handle partition-sets. [HIVE-9679] - Remove redundant null-checks from DbNotificationListener. [HIVE-9680] - GlobalLimitOptimizer is not checking filters correctly [HIVE-9681] - Extend HiveAuthorizationProvider to support partition-sets. [HIVE-9706] - HBase handler support for snapshots should confirm properties before use [HIVE-9711] - ORC Vectorization DoubleColumnVector.isRepeating=false if all entries are NaN [HIVE-9716] - Map job fails when table's LOCATION does not have scheme [HIVE-9717] - The max/min function used by AggrStats for decimal type is not what we expected [HIVE-9720] - Metastore does not properly migrate column stats when renaming a table across databases. [HIVE-9721] - Hadoop23Shims.setFullFileStatus should check for null [HIVE-9727] - GroupingID translation from Calcite [HIVE-9731] - WebHCat MapReduce Streaming Job does not allow StreamXmlRecordReader to be specified [HIVE-9734] - Correlating expression cannot contain unqualified column references [HIVE-9735] - aggregate ( smalllint ) fails when ORC file used ava.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Short [HIVE-9743] - Incorrect result set for vectorized left outer join [HIVE-9749] - ObjectStore schema verification logic is incorrect [HIVE-9754] - rename GenericUDFLevenstein to GenericUDFLevenshtein [HIVE-9755] - Hive built-in "ngram" UDAF fails when a mapper has no matches. [HIVE-9767] - Fixes in Hive UDF to be usable in Pig [HIVE-9770] - Beeline ignores --showHeader for non-tablular output formats i.e csv,tsv,dsv [HIVE-9772] - Hive parquet timestamp conversion doesn't work with new Parquet [HIVE-9779] - ATSHook does not log the end user if doAs=false (it logs the hs2 server user) [HIVE-9791] - insert into table throws NPE [HIVE-9797] - Need update some spark tests for java 8 [HIVE-9813] - Hive JDBC - DatabaseMetaData.getColumns method cannot find classes added with "add jar" command [HIVE-9817] - fix DateFormat pattern in hive-exec [HIVE-9826] - Firing insert event fails on temporary table [HIVE-9831] - HiveServer2 should use ConcurrentHashMap in ThreadFactory [HIVE-9832] - Merge join followed by union and a map join in hive on tez fails. [HIVE-9834] - VectorGroupByOperator logs too much [HIVE-9836] - Hive on tez: fails when virtual columns are present in the join conditions (for e.g. partition columns) [HIVE-9839] - HiveServer2 leaks OperationHandle on async queries which fail at compile phase [HIVE-9841] - IOException thrown by ORC should include the path of processing file [HIVE-9845] - HCatSplit repeats information making input split data size huge [HIVE-9848] - readlink -f is GNU coreutils only (used in bin/hive) [HIVE-9851] - org.apache.hadoop.hive.serde2.avro.AvroSerializer should use org.apache.avro.generic.GenericData.Array when serializing a list [HIVE-9855] - Runtime skew join doesn't work when skewed data only exists in big table [HIVE-9860] - MapredLocalTask/SecureCmdDoAs leaks local files [HIVE-9866] - Changing a column's type doesn't change column stats type in metastore [HIVE-9869] - Trunk doesn't build with hadoop-1 [HIVE-9873] - Hive on MR throws DeprecatedParquetHiveInput exception [HIVE-9877] - Beeline cannot run multiple statements in the same row [HIVE-9886] - Hive on tez: NPE when converting join to SMB in sub-query [HIVE-9892] - various MSSQL upgrade scripts don't work [HIVE-9908] - vectorization error binary type not supported, group by with binary columns [HIVE-9915] - Allow specifying file format for managed tables [HIVE-9919] - upgrade scripts don't work on some auto-created DBs due to absence of tables [HIVE-9920] - DROP DATABASE IF EXISTS throws exception if database does not exist [HIVE-9923] - No clear message when "from" is missing [HIVE-9929] - StatsUtil#getAvailableMemory could return negative value [HIVE-9930] - fix QueryPlan.makeQueryId time format [HIVE-9932] - DDLTask.conf hides base class Task.conf [HIVE-9934] - Vulnerability in LdapAuthenticationProviderImpl enables HiveServer2 client to degrade the authentication mechanism to "none", allowing authentication without password [HIVE-9936] - fix potential NPE in DefaultUDAFEvaluatorResolver [HIVE-9944] - Convert array[] to string properly in log messages [HIVE-9945] - FunctionTask.conf hides Task.conf field [HIVE-9947] - ScriptOperator replaceAll uses unescaped dot and result is not assigned [HIVE-9948] - SparkUtilities.getFileName passes File.separator to String.split() method [HIVE-9950] - fix rehash in CuckooSetBytes and CuckooSetLong [HIVE-9951] - VectorizedRCFileRecordReader creates Exception but does not throw it [HIVE-9952] - fix NPE in CorrelationUtilities [HIVE-9953] - fix NPE in WindowingTableFunction [HIVE-9954] - UDFJson uses the == operator to compare Strings [HIVE-9955] - TestVectorizedRowBatchCtx compares byte[] using equals() method [HIVE-9956] - use BigDecimal.valueOf instead of new in TestFileDump [HIVE-9957] - Hive 1.1.0 not compatible with Hadoop 2.4.0 [HIVE-9961] - HookContext for view should return a table type of VIRTUAL_VIEW [HIVE-9971] - Clean up operator class [HIVE-9975] - Renaming a nonexisting partition should not throw out NullPointerException [HIVE-9976] - Possible race condition in DynamicPartitionPruner for <200ms tasks [HIVE-9977] - Compactor not running on partitions after dynamic partitioned insert [HIVE-9984] - JoinReorder's getOutputSize is exponential [HIVE-9991] - Cannot do a SELECT on external tables that are on S3 due to Encryption error [HIVE-9994] - Hive query plan returns sensitive data to external applications [HIVE-9997] - minor tweaks for bytes mapjoin hash table [HIVE-10001] - SMB join in reduce side [HIVE-10032] - Remove HCatalog broken java file from source code [HIVE-10042] - clean up TreeReaders - ORC refactoring for LLAP on trunk [HIVE-10050] - Support overriding memory configuration for AM launched for TempletonControllerJob [HIVE-10059] - Make udaf_percentile_approx_23.q test more stable [HIVE-10062] - HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data [HIVE-10066] - Hive on Tez job submission through WebHCat doesn't ship Tez artifacts [HIVE-10074] - Ability to run HCat Client Unit tests in a system test setting [HIVE-10078] - Optionally allow logging of records processed in fixed intervals [HIVE-10083] - SMBJoin fails in case one table is uninitialized [HIVE-10085] - Lateral view on top of a view throws RuntimeException [HIVE-10086] - Hive throws error when accessing Parquet file schema using field name match [HIVE-10087] - Beeline's --silent option should suppress query from being echoed when running with -f option [HIVE-10093] - Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2 [HIVE-10095] - format_number udf throws NPE [HIVE-10098] - HS2 local task for map join fails in KMS encrypted cluster [HIVE-10106] - Regression : Dynamic partition pruning not working after HIVE-9976 [HIVE-10108] - Index#getIndexTableName() returns db.index_table_name [HIVE-10122] - Hive metastore filter-by-expression is broken for non-partition expressions [HIVE-10123] - Hybrid grace Hash join : Use estimate key count from stats to initialize BytesBytesMultiHashMap [HIVE-10128] - BytesBytesMultiHashMap does not allow concurrent read-only access [HIVE-10136] - BaseWork.vectorMode hides AbstractOperatorDesc.vectorMode [HIVE-10145] - set Tez ACLs appropriately in hive [HIVE-10148] - update of bucketing column should not be allowed [HIVE-10150] - delete from acidTbl where a in(select a from nonAcidOrcTbl) fails [HIVE-10151] - insert into A select from B is broken when both A and B are Acid tables and bucketed the same way [HIVE-10152] - ErrorMsg.formatToErrorMsgMap has bad regex [HIVE-10167] - HS2 logs the server started only before the server is shut down [HIVE-10172] - Fix performance regression caused by HIVE-8122 for ORC [HIVE-10178] - DateWritable incorrectly calculates daysSinceEpoch for negative Unix time [HIVE-10186] - Hive does not log Tez diagnostics on errors [HIVE-10197] - Add lockId to all ACID log statements [HIVE-10202] - Beeline outputs prompt+query on standard output when used in non-interactive mode [HIVE-10208] - templeton.hive.extra.files should be commented out in webhcat-default.xml [HIVE-10213] - MapReduce jobs using dynamic-partitioning fail on commit. [HIVE-10225] - CLI JLine does not flush history on quit/Ctrl-C [HIVE-10226] - Column stats for Date columns not supported [HIVE-10229] - Set conf and processor context in the constructor instead of init [HIVE-10231] - Compute partition column stats fails if partition col type is date [HIVE-10242] - ACID: insert overwrite prevents create table command [HIVE-10265] - Hive CLI crashes on != inequality [HIVE-10267] - HIVE-9664 makes hive depend on ivysettings.xml : trivial breakage fix [HIVE-10269] - HiveMetaStore.java:[6089,29] cannot find symbol class JvmPauseMonitor [HIVE-10270] - Cannot use Decimal constants less than 0.1BD [HIVE-10271] - remove hive.server2.thrift.http.min/max.worker.threads properties [HIVE-10272] - Some HCat tests fail under windows [HIVE-10273] - Union with partition tables which have no data fails with NPE [HIVE-10274] - Send context and description to tez via dag info [HIVE-10275] - GenericUDF getTimestampValue should return Timestamp instead of Date [HIVE-10284] - enable container reuse for grace hash join [HIVE-10285] - Incorrect endFunction call in HiveMetaStore [HIVE-10286] - SARGs: Type Safety via PredicateLeaf.type [HIVE-10288] - Cannot call permanent UDFs [HIVE-10290] - Add negative test case to modify a non-existent config value when hive security authorization is enabled. [HIVE-10303] - HIVE-9471 broke forward compatibility of ORC files [HIVE-10305] - TestOrcFile has a mistake that makes metadata test ineffective [HIVE-10306] - We need to print tez summary when hive.server2.logging.level >= PERFORMANCE. [HIVE-10309] - TestJdbcWithMiniHS2.java broken because of the removal of hive.server2.thrift.http.max.worker.threads [HIVE-10312] - SASL.QOP in JDBC URL is ignored for Delegation token Authentication [HIVE-10313] - Literal Decimal ExprNodeConstantDesc should contain value of HiveDecimal instead of String [HIVE-10318] - The HMS upgrade test does not test patches that affect the upgrade test scripts [HIVE-10323] - Tez merge join operator does not honor hive.join.emit.interval [HIVE-10324] - Hive metatool should take table_param_key to allow for changes to avro serde's schema url key [HIVE-10331] - ORC : Is null SARG filters out all row groups written in old ORC format [HIVE-10340] - Enable ORC test for timezone reading from old format [HIVE-10346] - Tez on HBase has problems with settings again [HIVE-10364] - The HMS upgrade script test does not publish results when prepare.sh fails. [HIVE-10367] - org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.* fails in Windows [HIVE-10370] - Hive does not compile with -Phadoop-1 option [HIVE-10372] - Update parquet version to 1.6.0 [HIVE-10374] - Revert HIVE-10304 deprecation message to HiveCLI [HIVE-10384] - RetryingMetaStoreClient does not retry wrapped TTransportExceptions [HIVE-10407] - separate out the timestamp ranges for testing purposes [HIVE-10409] - Webhcat tests need to be updated, to accomodate HADOOP-10193 [HIVE-10421] - DROP TABLE with qualified table name ignores database name when checking partitions [HIVE-10428] - NPE in RegexSerDe using HCat [HIVE-10431] - HIVE-9555 broke hadoop-1 build [HIVE-10437] - NullPointerException on queries where map/reduce is not involved on tables with partitions [HIVE-10441] - Fix confusing log statement in SessionState about hive.execution.engine setting [HIVE-10442] - HIVE-10098 broke hadoop-1 build [HIVE-10443] - HIVE-9870 broke hadoop-1 build [HIVE-10444] - HIVE-10223 breaks hadoop-1 build [HIVE-10446] - Hybrid Hybrid Grace Hash Join : java.lang.IllegalArgumentException in Kryo while spilling big table [HIVE-10447] - Beeline JDBC Driver to support 2 way SSL [HIVE-10450] - More than one TableScan in MapWork not supported in Vectorization -- causes query to fail during vectorization [HIVE-10451] - PTF deserializer fails if values are not used in reducer [HIVE-10456] - Grace Hash Join should not load spilled partitions on abort [HIVE-10465] - whitelist restrictions don't get initialized in new copy of HiveConf [HIVE-10472] - Jenkins HMS upgrade test is not publishing results because JIRAService class is not found. [HIVE-10477] - Provide option to disable Spark tests [HIVE-10481] - ACID table update finishes but values not really updated if column names are not all lower case [HIVE-10483] - insert overwrite partition deadlocks on itself with DbTxnManager [HIVE-10484] - Vectorization : RuntimeException "Big Table Retained Mapping duplicate column" [HIVE-10490] - HBase Snapshot IF fails at run time with missing dependency of MetricsRegistry [HIVE-10499] - Ensure Session/ZooKeeperClient instances are closed [HIVE-10500] - Repeated deadlocks in underlying RDBMS cause transaction or lock failure [HIVE-10507] - Expose RetryingMetastoreClient to other external users of metastore client like Flume and Storm. [HIVE-10508] - Strip out password information from config passed to Tez/MR in cases where password encryption is not used [HIVE-10510] - Change 1.2.0-SNAPSHOT to 1.2.0 in branch-1.2 [HIVE-10513] - [CBO] return path : Fix create_func1.q for return path [HIVE-10514] - Fix MiniCliDriver tests failure [HIVE-10517] - HCatPartition should not be created with "" as location in tests [HIVE-10521] - TxnHandler.timeOutTxns only times out some of the expired transactions [HIVE-10529] - Remove references to tez task context before storing operator plan in object cache [HIVE-10530] - Aggregate stats cache: bug fixes for RDBMS path [HIVE-10538] - Fix NPE in FileSinkOperator from hashcode mismatch [HIVE-10539] - set default value of hive.repl.task.factory [HIVE-10542] - Full outer joins in tez produce incorrect results in certain cases [HIVE-10543] - improve error message in MetaStoreAuthzAPIAuthorizerEmbedOnly [HIVE-10544] - Beeline/Hive JDBC Driver fails in HTTP mode on Windows with java.lang.NoSuchFieldError: INSTANCE [HIVE-10548] - Remove dependency to s3 repository in root pom [HIVE-10564] - webhcat should use webhcat-site.xml properties for controller job submission [HIVE-10572] - Improve Hive service test to check empty string [HIVE-10576] - add jar command does not work with Windows OS [HIVE-10578] - update sql standard authorization configuration whitelist [HIVE-10579] - Fix -Phadoop-1 build [HIVE-10595] - Dropping a table can cause NPEs in the compactor [HIVE-10603] - increase default permgen space for HS2 on windows [HIVE-10604] - update webhcat-default.xml with 1.2 version numbers [HIVE-10607] - Combination of ReducesinkDedup + TopN optimization yields incorrect result if there are multiple GBY in reducer [HIVE-10609] - Vectorization : Q64 fails with ClassCastException [HIVE-10610] - hive command fails to get hadoop version [HIVE-10612] - HIVE-10578 broke TestSQLStdHiveAccessControllerHS2 tests [HIVE-10614] - schemaTool upgrade from 0.14.0 to 1.3.0 causes failure [HIVE-10638] - HIVE-9736 introduces issues with Hadoop23Shims.checkFileAccess [HIVE-10688] - constant folding is broken for case-when udf [HIVE-10715] - RAT failures - many files do not have ASF licenses 改进 [HIVE-1575] - get_json_object does not support JSON array at the root level [HIVE-2573] - Create per-session function registry [HIVE-3185] - allow union set operation without ALL keyword (align to ISO-SQL 2011 specification) [HIVE-5472] - support a simple scalar which returns the current timestamp [HIVE-7175] - Provide password file option to beeline [HIVE-8385] - UNION Operator in Hive [HIVE-9138] - Add some explain to PTF operator [HIVE-9143] - select user(), current_user() [HIVE-9298] - Support reading alternate timestamp formats [HIVE-9470] - Use a generic writable object to run ColumnaStorageBench write/read tests [HIVE-9480] - Build UDF TRUNC to implement FIRST_DAY as compared with LAST_DAY [HIVE-9500] - Support nested structs over 24 levels. [HIVE-9518] - Implement MONTHS_BETWEEN aligned with Oracle one [HIVE-9521] - Drop support for Java6 [HIVE-9556] - create UDF to calculate the Levenshtein distance between two strings [HIVE-9564] - Extend HIVE-9298 for JsonSerDe [HIVE-9590] - add qtests for ADD_MONTHS UDF [HIVE-9594] - Add qtests for LAST_DAY udf [HIVE-9596] - move standard getDisplayString impl to GenericUDF [HIVE-9607] - Remove unnecessary attach-jdbc-driver execution from package/pom.xml [HIVE-9618] - Deduplicate RS keys for ptf/windowing [HIVE-9664] - Hive "add jar" command should be able to download and add jars from a repository [HIVE-9673] - Set operationhandle in ATS entities for lookups [HIVE-9699] - Extend PTFs to provide referenced columns for CP [HIVE-9709] - Hive should support replaying cookie from JDBC driver for beeline [HIVE-9710] - HiveServer2 should support cookie based authentication, when using HTTP transport. [HIVE-9738] - create SOUNDEX udf [HIVE-9744] - Move common arguments validation and value extraction code to GenericUDF [HIVE-9766] - Add JavaConstantXXXObjectInspector [HIVE-9788] - Make double quote optional in tsv/csv/dsv output [HIVE-9793] - Remove hard coded paths from cli driver tests [HIVE-9800] - Create scripts to do metastore upgrade tests on Jenkins [HIVE-9857] - Create Factorial UDF [HIVE-9858] - Create cbrt (cube root) UDF [HIVE-9859] - Create bitwise left/right shift UDFs [HIVE-9870] - Add JvmPauseMonitor threads to HMS and HS2 daemons [HIVE-9909] - Specify hive branch to use on jenkins hms tests [HIVE-9914] - Post success comments on Jira from Jenkins metastore upgrades scripts [HIVE-9917] - After HIVE-3454 is done, make int to timestamp conversion configurable [HIVE-9981] - Avoid throwing many exceptions when attempting to create new hdfs encryption shim [HIVE-10007] - Support qualified table name in analyze table compute statistics for columns [HIVE-10027] - Use descriptions from Avro schema files in column comments [HIVE-10072] - Add vectorization support for Hybrid Grace Hash Join [HIVE-10114] - Split strategies for ORC [HIVE-10119] - Allow Log verbosity to be set in hiveserver2 session [HIVE-10120] - Disallow create table with dot/colon in column name [HIVE-10146] - Not count session as idle if query is running [HIVE-10160] - Give a warning when grouping or ordering by a constant column [HIVE-10177] - Enable constant folding for char & varchar [HIVE-10206] - Improve Alter Table to not initialize Serde unnecessarily [HIVE-10214] - log metastore call timing information aggregated at query level [HIVE-10216] - log hive cli classpath at debug level [HIVE-10223] - Consolidate several redundant FileSystem API calls. [HIVE-10276] - Implement date_format(timestamp, fmt) UDF [HIVE-10307] - Support to use number literals in partition column [HIVE-10339] - Allow JDBC Driver to pass HTTP header Key/Value pairs [HIVE-10382] - Aggregate stats cache for RDBMS based metastore codepath [HIVE-10403] - Add n-way join support for Hybrid Grace Hash Join [HIVE-10467] - Switch to GIT repository on Jenkins precommit tests [HIVE-10546] - genFileSinkPlan should use the generated SEL's RR for the partition col of FS [HIVE-10568] - Select count(distinct()) can have more optimal execution plan 新特性 [HIVE-7998] - Enhance JDBC Driver to not require class specification [HIVE-9039] - Support Union Distinct [HIVE-9188] - BloomFilter support in ORC [HIVE-9277] - Hybrid Hybrid Grace Hash Join [HIVE-9302] - Beeline add commands to register local jdbc driver names and jars [HIVE-9780] - Add another level of explain for RDBMS audience [HIVE-10038] - Add Calcite's ProjectMergeRule. [HIVE-10099] - Enable constant folding for Decimal [HIVE-10591] - Support limited integer type promotion in ORC [HIVE-10636] - CASE comparison operator rotation optimization Regards, The Apache Hive Team Apache Hive 1.2.0 发布，数据仓库平台下载地址
