Grokbase Groups Hive user June 2010
FAQ
Dear Hive Community,

I've been trying to see if Hive (0.5.0) supports data type validation when
loading data into it. My initial experiments show me that if it is of wrong
data type (vs the table definition), the values seem to be NULL. Is it
correct?

Can anyone point to useful resources with respect to this?

~
Best,
Pavan

Search Discussions

  • Yongqiang he at Jun 3, 2010 at 6:56 am
    Right now Hive does not do data validation when loading data into a table.
    If you load some wrong data which does not conform the table
    definition, queries on that table may fail or results are meaningless.
    On Wed, Jun 2, 2010 at 11:09 PM, Pavan wrote:
    Dear Hive Community,
    I've been trying to see if Hive (0.5.0) supports data type validation when
    loading data into it. My initial experiments show me that if it is of wrong
    data type (vs the table definition), the values seem to be NULL. Is it
    correct?
    Can anyone point to useful resources with respect to this?
    ~
    Best,
    Pavan
  • Pavan at Jun 3, 2010 at 7:32 am
    Thanks yongqiang he.

    Is there any alternative method to do data (type) validation in Hive?


    ~
    Thanks,
    Pavan
    *

    On Thu, Jun 3, 2010 at 12:25 PM, yongqiang he wrote:

    Right now Hive does not do data validation when loading data into a table.
    If you load some wrong data which does not conform the table
    definition, queries on that table may fail or results are meaningless.
    On Wed, Jun 2, 2010 at 11:09 PM, Pavan wrote:
    Dear Hive Community,
    I've been trying to see if Hive (0.5.0) supports data type validation when
    loading data into it. My initial experiments show me that if it is of wrong
    data type (vs the table definition), the values seem to be NULL. Is it
    correct?
    Can anyone point to useful resources with respect to this?
    ~
    Best,
    Pavan

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedJun 3, '10 at 6:10a
activeJun 3, '10 at 7:32a
posts3
users2
websitehive.apache.org

2 users in discussion

Pavan: 2 posts Yongqiang he: 1 post

People

Translate

site design / logo © 2023 Grokbase