Hortonworks Sandbox Forum

Hive Data Loss

  • #19957
    Sarang Patil
    Member

    What we notice is that as soon as hadoop instance is shutdown we are losing all the data within hive external tables as well as form hdfs.

    To give you an example…
    1. We created external hive table ext_stockdata on 4/1
    2. select from the ext_stockdata => Was successful and returned the result.
    3. Loged out of Hive and Shut down the instance
    4. Restarted the instance Loged back in Hive
    5. select from the ext_stockdata => Was successful but we lost all the data in the table

    We replicated this test today morning. After rebooting got no Data back ? Is this intended behaviour of the sandbox?….

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #19960
    Seth Lyubich
    Moderator

    Hi Sarang,

    Can you please let us know which Hortonworks Sandbox version you are using?

    Thanks,
    Seth

    #19961
    Sarang Patil
    Member

    [root@hortonworks-sandbox ~]# hadoop version
    Hadoop 1.0.3.15
    Subversion -r
    Compiled by jenkins on Thu Aug 30 14:53:12 PDT 2012
    From source with checksum 434d0419e24d8f7e049e1a02a387b5d3

    #19973
    Seth Lyubich
    Moderator

    Hi Sarang,

    Thanks for providing information. This information shows installed hadoop version. Can you please tell us the name you see on appliance itself?

    Thanks,
    Seth

    #20233
    Sarang Patil
    Member

    Name you see on appliance ? Seth – I am not sure what you are looking for. We have this installed in Amazons EC2 Cloud.

    #20345
    tedr
    Member

    Hi Sarang,

    Are you sure that you are using the Hortonworks Sandbox? The Sandbox is a virtual appliance created to be imported into either VMware or Virtualbox, so it’s kind of puzzling as to how you installed it in the Amazon cloud.
    But with regard to whether or not the behavior you are seeing is normal for the Sandbox, it is not, but it is normal for an EC2 image. If you use the Sandbox inside VMware or Virtualbox as intended, you data will remain after a reboot.

    Thanks
    Ted.

    #20460
    Sarang Patil
    Member

    Ted;

    You Puzzled me too…….Royaly….. Here is the AMI we are using….. AMI: Hortonworks-HDP-1.1.0.15-Single-Node (ami-754bfa1c). EBS is attached to the instance:

    How do i verify where the hfd is created on the persistent disk which is called an “EBS volume.”

    #20462
    Seth Lyubich
    Moderator

    Hi Sarang,

    I think I know the source of confusion here. I think you are using Virtual Sandbox which is an older Sandbox product that was launched from EC2. New Hortonworks Sandbox can be found here:
    http://hortonworks.com/products/hortonworks-sandbox/

    All you need to do is to import appliance to your VM environment.

    Hope this helps,

    Thanks,
    Seth

You must be to reply to this topic. | Create Account

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.