You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Raymond Lau <rl...@ooyala.com> on 2014/07/15 02:09:22 UTC
External partition table question
I've created an external table partitioned by a field and am attempting to
load in the data via the command 'ALTER TABLE partitioned_table_test ADD
PARTITION (pcode = '123') LOCATION '/path/to/parquet/files';' using a
custom Parquet SerDe.
Does loading in the data this way call the serializer() function in the
SerDe at all?
I've tried adding System.out.println statements in my deserializer and
serializer to debug and no output seems to come from the Serializer
function.
--
*Raymond Lau*
Software Engineer - Intern |
rlau@ooyala.com | (925) 395-3806
Re: External partition table question
Posted by Lefty Leverenz <le...@gmail.com>.
Thanks for this clarification. I've revised the Add Partitions section
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AddPartitions>
in the wiki accordingly.
-- Lefty
On Fri, Jul 18, 2014 at 12:45 AM, Satish Mittal <sa...@inmobi.com>
wrote:
> 'ALTER TABLE .. ADD PARTITION..' would just a partition entry for the
> table in hive metastore. It doesn't perform any data loading, instead it
> expects the data to be loaded already in the file pointed to by LOCATION.
>
>
> On Tue, Jul 15, 2014 at 5:39 AM, Raymond Lau <rl...@ooyala.com> wrote:
>
>> I've created an external table partitioned by a field and am attempting
>> to load in the data via the command 'ALTER TABLE partitioned_table_test ADD
>> PARTITION (pcode = '123') LOCATION '/path/to/parquet/files';' using a
>> custom Parquet SerDe.
>>
>> Does loading in the data this way call the serializer() function in the
>> SerDe at all?
>>
>> I've tried adding System.out.println statements in my deserializer and
>> serializer to debug and no output seems to come from the Serializer
>> function.
>>
>> --
>> *Raymond Lau*
>> Software Engineer - Intern |
>> rlau@ooyala.com | (925) 395-3806
>>
>
>
> _____________________________________________________________
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it. It may contain confidential or legally privileged
> information. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify
> us immediately by responding to this email and then delete it from your
> system. The firm is neither liable for the proper and complete transmission
> of the information contained in this communication nor for any delay in its
> receipt.
Re: External partition table question
Posted by Satish Mittal <sa...@inmobi.com>.
'ALTER TABLE .. ADD PARTITION..' would just a partition entry for the table
in hive metastore. It doesn't perform any data loading, instead it expects
the data to be loaded already in the file pointed to by LOCATION.
On Tue, Jul 15, 2014 at 5:39 AM, Raymond Lau <rl...@ooyala.com> wrote:
> I've created an external table partitioned by a field and am attempting to
> load in the data via the command 'ALTER TABLE partitioned_table_test ADD
> PARTITION (pcode = '123') LOCATION '/path/to/parquet/files';' using a
> custom Parquet SerDe.
>
> Does loading in the data this way call the serializer() function in the
> SerDe at all?
>
> I've tried adding System.out.println statements in my deserializer and
> serializer to debug and no output seems to come from the Serializer
> function.
>
> --
> *Raymond Lau*
> Software Engineer - Intern |
> rlau@ooyala.com | (925) 395-3806
>
--
_____________________________________________________________
The information contained in this communication is intended solely for the
use of the individual or entity to whom it is addressed and others
authorized to receive it. It may contain confidential or legally privileged
information. If you are not the intended recipient you are hereby notified
that any disclosure, copying, distribution or taking any action in reliance
on the contents of this information is strictly prohibited and may be
unlawful. If you have received this communication in error, please notify
us immediately by responding to this email and then delete it from your
system. The firm is neither liable for the proper and complete transmission
of the information contained in this communication nor for any delay in its
receipt.