Re: Apache Hive 2.3.4 - Issue with combination of Like operator & newline (\n) character in data

2019-07-29 Thread Shankar Mane
It will worked when your aware of data. This solution is not suitable when column data is unknown and dynamic in nature. On Mon, 29 Jul 2019, 21:50 Sungwoo Park, wrote: > Not a solution, but one can use \n in the search string, e.g.: > > select * from default.withdraw where id like

Re: Apache Hive 2.3.4 - Issue with combination of Like operator & newline (\n) character in data

2019-07-29 Thread Sungwoo Park
Not a solution, but one can use \n in the search string, e.g.: select * from default.withdraw where id like '%withdraw\ncash'; select * from default.withdraw where id like '%withdraw%\ncash'; select * from default.withdraw where id like '%withdraw%\n%cash'; --- Sungwoo On Tue, Jul 30, 2019 at

Re: Apache Hive 2.3.4 - Issue with combination of Like operator & newline (\n) character in data

2019-07-29 Thread Shankar Mane
Can anyone looking at this issue ? On Sat, Jul 20, 2019 at 9:08 AM Shankar Mane wrote: > Have created jira at https://issues.apache.org/jira/browse/HIVE-22008 >

Re: Performance issue about DESC FORMATTED query

2019-07-29 Thread Yuya Ebihara
Posted the same issue on Stackoverflow so that I can update the detail. https://stackoverflow.com/questions/57250948/performance-issue-about-describe-formatted-query BR, Yuya On Fri, Jul 26, 2019 at 10:22 PM Yuya Ebihara wrote: > Hi, this is my first post to Hive community. > > We faced