values are just concatenated together (at least for Hive
0.9.0 that I'm using).
For my case it is relevantly easy to construct JSON strings by myself, but I
wonder if there is a more standardized way to do so.
Thanks,
Sha Liu
the "where
clause" not be supported with that syntax? something's rotten in denmark there
with your query.
what version of hive are you seeing this on?
On Tue, Jul 30, 2013 at 9:34 PM, Sha Liu wrote:
Doesn't INSERT INTO do what you said? I'm not sure
, then
you can insert a whole partition at a time instead of the table.
Thanks,Brad
On Tue, Jul 30, 2013 at 9:04 PM, Sha Liu wrote:
Yes for the example you gave, it works. It even works when there is a single
insert under the from clause, but there there are multiple inserts, the where
cl
...@radiumone.com
To: user@hive.apache.org
Have you simply tried
INSERT OVERWRITE TABLE destination SELECT col1, col2, col3FROM sourceWHERE col4
= 'abc'
Thanks!
On Tue, Jul 30, 2013 at 8:25 PM, Sha Liu wrote:
Hi Hive Gurus,
When using the Hive extension of multiple inserts, can we
col3='xyz'
The underlined parts didn't cause any errors, but they didn't seem to be
effective either (I'm using Hive 0.9). Note that the columns used in the Where
clauses are not among the selected ones, but I'm not sure if that is important.
Is this kind of operations supported?
Thanks,Sha Liu
steps. We can run a select
query on the 2nd table (column names) to get the column list, and generate
another Hive query based on this list, but this approach needs to run two
separate queries. Are there more efficient ways of achieving the same?
Thanks,Sha Liu
ns or just run by
themselves.
Thanks,Sha Liu
