I did. Besides, the query is broken, not the schema. If I perform this query
from the mysql
command prompt, the escape has to be specified as ESCAPE ‘\\'
> On Nov 19, 2015, at 6:46 PM, Artem Ervits wrote:
>
> Confirm Hive metastore schema update scripts have run.
>
> On Nov 19, 2015 11:39 AM,
Confirm Hive metastore schema update scripts have run.
On Nov 19, 2015 11:39 AM, "Brian Jeltema" wrote:
> Following up, I turned on logging in the MySQL server to capture the
> failing query. The query being logged by MySQL is
>
> SELECT `A0`.`NAME` AS NUCORDER0 FROM `DBS` `A0` WHERE
> LOWER(`A
Following up, I turned on logging in the MySQL server to capture the failing
query. The query being logged by MySQL is
SELECT `A0`.`NAME` AS NUCORDER0 FROM `DBS` `A0` WHERE LOWER(`A0`.`NAME`) LIKE
'_%' ESCAPE '\' ORDER BY NUCORDER0
which I believe is failing because the backslash in the ESCAP
Originally posted in the Ambari users group, but probably more appropriate here:
I’ve done a rolling upgrade to HDP 2.3 and everything appears to be working now
except for Hive. The HiveServer2
process is shown as ‘Started’, but it’s really broken, as is the Hive
Metastore. HiveServer2 is not li
