'-MM-dd')
Thanks!
anci_...@yahoo.com
From: Alan Gates
Date: 2018-09-22 07:19
To: user; anci_sun
Subject: Re: Question about OVER clause
This article might be helpful. It's for SQL Server, but the semantics should
be similar.
https://www.sqlpassion.at/archive/2015/0
Dears,
I found an interesting thing.
When inserting a NULL result into a partition which already contained some
records, there was a difference in the results between using static partition
INSERT and using dynamic partition INSERT.
See the example below:
Partition '20180101
nvi Thacker
On Tue, Oct 23, 2018 at 9:38 PM anci_...@yahoo.com wrote:
Dears,
I found an interesting thing.
When inserting a NULL result into a partition which already contained some
records, there was a difference in the results between using static partition
INSERT and using dynamic p
Dears,
I had taken a SELECT script with 90 sets in one GROUPING, and there was a
serious data skewing problem.
Was it concerned with the too many GROUPING SETS and how to solve it?
( I couldn't simply set hive.groupby.skewindata to true because there were
some COUNT(DISTINCT ...) in i
Dears,
I see that using '\s' can get the whitespace character in normal java
regular expressions, but in HIVE I found it couldn't.
Why? And is there any other differences between the regular expressions in
JAVA and HIVE?
Regards,
孙志禹
