[jira] [Created] (HIVE-24361) Insert overwrite with empty data is different in normal table then transactional table
ABHISHEK KUMAR GUPTA created HIVE-24361: --- Summary: Insert overwrite with empty data is different in normal table then transactional table Key: HIVE-24361 URL: https://issues.apache.org/jira/browse/HIVE-24361 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 3.1.0 Reporter: ABHISHEK KUMAR GUPTA Steps: Use Case 1: create table test3(id int); insert into table test3 values(20); create table test4(id int); insert overwrite table test3 select * from test4; select * from test 3; Result: 0 rows Use Case 2: For transnational Table: create table test1(id int) stored as orc tblproperties('transactional'='true'); insert into test1 values(20); create table test2(id int) stored as orc tblproperties('transactional'='true'); insert overwrite table test1 select * from test2; select * from test 1; Result: 1 rows Expectation: Use Case 1 should behave as Use Case 2. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-24057) Hive beeline not throw Error when update a varchar column value is exceed the length length
ABHISHEK KUMAR GUPTA created HIVE-24057: --- Summary: Hive beeline not throw Error when update a varchar column value is exceed the length length Key: HIVE-24057 URL: https://issues.apache.org/jira/browse/HIVE-24057 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 3.1.0 Reporter: ABHISHEK KUMAR GUPTA 1. CREATE TABLE table013(orderkey int, orderstatus varchar(7), totalprice double, orderdate date) stored as orc tblproperties('transactional'='true'); 2. INSERT INTO table013 VALUES(10, 'SUCCESS', 125.15, DATE'2019-05-17'); 3. update table013 set orderkey=40,orderstatus='FAILEDD' where orderkey=10; Current behavior: Operation will be success. No error But select * from table013; does not update the column orderstatus. Expected: Should throw Mismatch column Error Msg as orderstatus column expect 7 length. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-23740) [Hive]delete from ; without where clause not giving correct error msg
ABHISHEK KUMAR GUPTA created HIVE-23740: --- Summary: [Hive]delete from ; without where clause not giving correct error msg Key: HIVE-23740 URL: https://issues.apache.org/jira/browse/HIVE-23740 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 3.1.0 Reporter: ABHISHEK KUMAR GUPTA Created Hive table from Hive Inserted data and fire delete from ; CREATE TABLE insert_only (key int, value string) STORED AS ORC TBLPROPERTIES ("transactional"="true", "transactional_properties"="insert_only"); INSERT INTO insert_only VALUES (13,'BAD'), (14,'SUCCESS'); delete from insert_only; Error throws: Error: Error while compiling statement: FAILED: SemanticException [Error 10414]: Attempt to do update or delete on table hive.insert_only that is insert-only transactional (state=42000,code=10414) Expectation: Should throw as where clause is missing because to delete all the content of table hive provides truncate table ; -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-22849) Regex for Hive built in functions giving different result
ABHISHEK KUMAR GUPTA created HIVE-22849: --- Summary: Regex for Hive built in functions giving different result Key: HIVE-22849 URL: https://issues.apache.org/jira/browse/HIVE-22849 Project: Hive Issue Type: Bug Affects Versions: 3.1.1 Environment: hive> show functions like 'ad?*'; OK abs acos add_months aes_decrypt aes_encrypt and array array_contains ascii asin assert_true atan avg Time taken: 0.005 seconds, Fetched: 13 row(s) hive> show functions like 'ad*'; OK add_months Time taken: 0.005 seconds, Fetched: 1 row(s) Reporter: ABHISHEK KUMAR GUPTA -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-22847) view created in presto throws Exception in Hive while accessing
ABHISHEK KUMAR GUPTA created HIVE-22847: --- Summary: view created in presto throws Exception in Hive while accessing Key: HIVE-22847 URL: https://issues.apache.org/jira/browse/HIVE-22847 Project: Hive Issue Type: Bug Reporter: ABHISHEK KUMAR GUPTA hive> select * from test_view; NoViableAltException(-1@[]) at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1300) at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:208) at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:77) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.replaceViewReferenceWithDefinition(SemanticAnalyzer.java:2443) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:2022) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1934) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:11080) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:11133) at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:286) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:258) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:512) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1317) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1457) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1237) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1227) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:233) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:184) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:686) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:226) at org.apache.hadoop.util.RunJar.main(RunJar.java:141) FAILED: SemanticException line 1:17 cannot recognize input near '' '' '' in definition of VIEW test_view [ /* Presto View */ ] used as test_view at Line 1:14 -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-22846) Hive metastore doesn’t support stats on container types
ABHISHEK KUMAR GUPTA created HIVE-22846: --- Summary: Hive metastore doesn’t support stats on container types Key: HIVE-22846 URL: https://issues.apache.org/jira/browse/HIVE-22846 Project: Hive Issue Type: Bug Components: SQL Affects Versions: 2.3.6 Reporter: ABHISHEK KUMAR GUPTA hive> CREATE TABLE `test_map_text`(`id` string,`score` map) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ( 'colelction.delim'=',','field.delim'='|','mapkey.delim'=':','serializaion.format'='|') STORED AS TEXTFILE; hive> LOAD DATA INPATH '/tmp/map.text' INTO TABLE test_map.text; This is my test_map.txt at HDFS location 1|Math:90,English:89 2|Math:88,English:90 3|Math:93,English:93 hive> analyze table test_map_text compute statistics for columns; hive> desc formatted test_map_text score; OK # col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment score map from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"id\":\"true\"}} Time taken: 0.053 seconds, Fetched: 4 row(s) -- This message was sent by Atlassian Jira (v8.3.4#803005)