ayushtkn commented on PR #4620:
URL: https://github.com/apache/hive/pull/4620#issuecomment-1703761134
Exploring a bit more
FWIW. Semi colon is the default delimiter not the only delimiter beeline can
have,
Launch your beeline session like
```
beeline -u 'jdbc:hive2://localhost:10000/' --delimiter='$'
```
And now this will use $ to terminate the queries rather than ;
So, having those ; doesn't make sense, when the delimiter changes to
something else, so the problem is not around semicolon but delimiter.
Secondly,
> We had also done this research. The point in prior comments is that other
systems do not output multiple lines.
[HIVE-25652](https://issues.apache.org/jira/browse/HIVE-25652) added these
alter statements where as other systems don't add these lines, I feel we went
wrong there itself, checking the example mentioned in that ticket, We created a
table using a **single** create statement, & in the show create table output
for the same create we show a different skeleton create statement & bunch of
alter to reach the state which that 'single' create statement led to, and as
the research says other system don't operate that way but return the same
create statement which was used to create the table.
I think we should also get rid of these alters & operate the way other
engines operate and I feel that is the correct way.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
