Not a definitive answer, but my test result might help. I tested with
HiveServer2 1.2.2 and Metastore 2.3.6. Queries in the TPC-DS benchmark
(which only read data and never update) run okay. Creating new tables and
loading data to tables also work okay. So, I guess for basic uses of Hive,
running H
Hi,
In order to have single hive metastore supporting different clusters of
hive, I have upgraded my hive metastore schema (on postgres) from version
1.1.0 to version 2.3.0. Will hive cluster on version 1.1.0 work if I point
it to upgraded metastore db which is as per hive version 2.3.0.
Thanks
Please try with subquery alias .
Regards
On Mon, Dec 9, 2019, 6:06 AM Dan Horne wrote:
> Hi All
>
> I'm trying to run the following subquery but it returns an error that says
> "cannot recognize input near 'select' 'max' '(' in expression specification"
>
> select id,
>
> first_name,
>
> last_n
Hi All
I'm trying to run the following subquery but it returns an error that says
"cannot recognize input near 'select' 'max' '(' in expression specification"
select id,
first_name,
last_name,
change_seq
from person_source
where change_seq >
(select max(change_seq) from person_target);
If
Hi,
When major compactions have been performed on Hive tables based on the Orc
format do we have Orc stripes that have been rewritten ? I know that records
have not been updated (ignored for some of ones but not updated) but concerning
Stripes size, do major compactions impact these ones ?
For e
