Hive / HCatalog Forum

Unable to display the data in the table

  • #30433
    Karthick S
    Member

    Hi,

    I have created a table using
    CREATE EXTERNAL TABLE person_analysis
    (id INT, name STRING, vehicle STRING, veh_value BIGINT,tv STRING, tv_value BIGINT)
    COMMENT ‘work’
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ’44’ LINES TERMINATED BY ‘\n’
    STORED AS TEXTFILE
    LOCATION ‘/user/hue';

    Looked like table creation was OK

    Then i tried displaying the data in the table

    select * from person_analysis;

    It throws an error “java.io.IOException: java.io.IOException: Not a file: hdfs://sandbox:8020/user/hue/jobsub”

    From Log:
    13/07/30 21:13:47 INFO ql.Driver:
    OK
    13/07/30 21:13:47 INFO ql.Driver: OK
    13/07/30 21:13:56 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
    13/07/30 21:13:56 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
    13/07/30 21:13:56 INFO mapred.FileInputFormat: Total input paths to process : 5
    13/07/30 21:13:56 ERROR security.UserGroupInformation: PriviledgedActionException as:hue cause:BeeswaxException(message:java.io.IOException: java.io.IOException: Not a file: hdfs://sandbox:8020/user/hue/jobsub, log_context:7ec8bc71-b0e4-4769-bc05-80fa93523a36, handle:QueryHandle(id:7ec8bc71-b0e4-4769-bc05-80fa93523a36, log_context:7ec8bc71-b0e4-4769-bc05-80fa93523a36), SQLState: )
    13/07/30 21:13:56 ERROR beeswax.BeeswaxServiceImpl: Caught BeeswaxException
    BeeswaxException(message:java.io.IOException: java.io.IOException: Not a file: hdfs://sandbox:8020/user/hue/jobsub, log_context:7ec8bc71-b0e4-4769-bc05-80fa93523a36, handle:QueryHandle(id:7ec8bc71-b0e4-4769-bc05-80fa93523a36, log_context:7ec8bc71-b0e4-4769-bc05-80fa93523a36), SQLState: )

    Looks like some issue with permission. could someone help on this ?

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #30491
    Seth Lyubich
    Moderator

    Hi,

    Yes, this looks like a permission issue. Can you please check your permissions on /user/hue and /user/hue/jobsub ?

    Hope this helps,

    Thanks,
    Seth

    #30515
    Karthick S
    Member

    Seth,
    Thanks for confirming. how do i check the permission of /user/hue and /user/hue/jobsub from sandbox shell ? Also please let me know how do i change the permission if there are permission issues.

    I tried

    [root@sandbox~]#hadoop fs -chmod 777 /user/hue

    but it throws the following error

    chmod: failed on ‘hdfs://sandbox:8020/user/hue': org.apache.hadoop.security.AccessControlException: Permission denied

    Thanks in advance.

    #30592
    Robert
    Participant

    Hi Member,
    I believe what’s occurring is that since your external table path is at /user/hue, there are so many folders and files in that location and hence probably does not like that. How about providing external table path of /user/hue/externaltab/tab1 ? Thus only put your data file in that location and verify if that resolves the error.

    Regards,
    Robert

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.