Home Forums Hortonworks Sandbox Unable to create table from the sample data filein HCatalog

This topic contains 2 replies, has 3 voices, and was last updated by  Siyaram Vishwakarma 3 months, 1 week ago.

  • Creator
    Topic
  • #30258

    Karthick S
    Member

    I am unable to create the table using the sample file in HCatalog. There seems to be some issues with the delimiter selection. Following is the error. Please let me know the right delimiter selection

    HCatClient error on create table: {“statement”:”use default; create table nyse_stocks(`exchange` string, `stock_symbol` string, `date` string, `stock_price_open` double, `stock_price_high` double, `stock_price_low` double, `stock_price_close` double, `stock_volume` bigint, `stock_price_adj_close` double) row format delimited fields terminated by ‘\\t’;”,”error”:”unable to create table: nyse_stocks”,”exec”:{“stdout”:”",”stderr”:”",”exitcode”:143}} (error 500)

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #51960

    Siyaram Vishwakarma
    Participant

    Hi karthick..did u get solution for this problem..if yes do let me know.

    Collapse
    #30529

    Cheryle Custer
    Moderator

    Hi,

    Can you please tell us which version of the Sandbox you’re using, which browser and which operating system?

    In the meantime, please reboot your VM and try again.

    Thanks,
    Cheryle

    Collapse
Viewing 2 replies - 1 through 2 (of 2 total)