[jira] [Created] (HIVE-27133) Round off limit value greater than int_max to int_max;
vamshi kolanu created HIVE-27133: Summary: Round off limit value greater than int_max to int_max; Key: HIVE-27133 URL: https://issues.apache.org/jira/browse/HIVE-27133 Project: Hive Issue Type: Task Reporter: vamshi kolanu Assignee: vamshi kolanu Currently when the limit has a bigint value, it fails with the following error. As part of this task, we are going to round off any value greater than int_max to int_max. select string_col from alltypes order by 1 limit 9223372036854775807 java.lang.NumberFormatException: For input string: "9223372036854775807" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:583) at java.lang.Integer.(Integer.java:867) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1803) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1911) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1911) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:12616) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:12718) at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:450) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:299) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:650) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1503) at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1450) at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1445) at org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126) at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:200) at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:265) at org.apache.hive.service.cli.operation.Operation.run(Operation.java:274) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:565) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:551) at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:315) at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:567) at org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1557) at org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1542) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) -- This message was sent by Atlassian Jira (v8.20.10#820010)
Re: [DISCUSS] HIVE 4.0 GA Release Proposal
Hi Kirti, Thanks for bringing up this topic. The master branch already has many new features; we don't need to wait for more to cut a GA. The main criterion for going GA is stability thus I would consider regressions as the only blockers for the release. If I recall well the only regressions discovered so far are some problems with TPC-DS queries so basically HIVE-26654 [1]. I will let others chime in to include more tickets if necessary. Best, Stamatis [1] https://issues.apache.org/jira/browse/HIVE-26654 On Wed, Mar 8, 2023 at 10:02 AM Kirti Ruge wrote: > Hello Hive Dev, > > It has been about 6 months since Hive-4.0-alpha-2 was released in Nov 2022. > Would it be a good time to discuss about HIVE-4.0 GA release to the > community ? Can we have discussion on the new features/jdk support versions > which we want to publish as part of 4.0 GA , timeframe of release. > > > Thanks, > Kirti
Unable to insert multi line records in hive
Hi folks, I have used the following script to insert insert into employee values (1,'Alex','123 street Tamilnadu India'); But the selection result like the following, 1,'Alex','123 street' null,null,null null,null,null If I insert the record in a single line, It was inserted perfectly insert into employee values (1,'Alex','123 street Tamilnadu India'); How to solve this ? Thanks, Karthick Ramu
[jira] [Created] (HIVE-27132) backport HIVE-12371 to branch-3 hive-jdbc use global Driver loginTimeout
shalk created HIVE-27132: Summary: backport HIVE-12371 to branch-3 hive-jdbc use global Driver loginTimeout Key: HIVE-27132 URL: https://issues.apache.org/jira/browse/HIVE-27132 Project: Hive Issue Type: Improvement Reporter: shalk -- This message was sent by Atlassian Jira (v8.20.10#820010)