[jira] [Created] (HIVE-22846) Hive metastore doesn’t support stats on container types

2020-02-06 Thread ABHISHEK KUMAR GUPTA (Jira) 
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)

[jira] [Created] (HIVE-22849) Regex for Hive built in functions giving different result

2020-02-06 Thread ABHISHEK KUMAR GUPTA (Jira) 
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

2020-02-06 Thread ABHISHEK KUMAR GUPTA (Jira) 
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-24057) Hive beeline not throw Error when update a varchar column value is exceed the length length

2020-08-21 Thread ABHISHEK KUMAR GUPTA (Jira) 
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

2020-06-22 Thread ABHISHEK KUMAR GUPTA (Jira) 
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-24361) Insert overwrite with empty data is different in normal table then transactional table

2020-11-08 Thread ABHISHEK KUMAR GUPTA (Jira) 
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)