FAQ
hive> create table abc(name STRING, age STRING)
row format delimited fields terminated by '/t'
stored as textfile;
FAILED: Error in metadata: MetaException(message:Got exception:
org.apache.hadoop.security.AccessControlException Permission denied:
user=root, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:205)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:186)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:135)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:4265)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkAncestorAccess(FSNamesystem.java:4236)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInternal(FSNamesystem.java:2628)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(FSNamesystem.java:2592)
at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mkdirs(NameNodeRpcServer.java:638)
at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.mkdirs(ClientNamenodeProtocolServerSideTranslatorPB.java:412)
at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java:42618)
at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:427)
at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:916)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1692)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1688)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1232)
at org.apache.hadoop.ipc.Server$Handler.run(Server.java:1686)
)
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask


--
Mahesh Bhat

Search Discussions

  • Mahesh Bhat at Sep 23, 2012 at 7:45 am
    Guys i have attached an error can you please look in to it and suggest....


    On 9/23/12, Mahesh Bhat wrote:
    hive> create table abc(name STRING, age STRING)
    row format delimited fields terminated by '/t'
    stored as textfile;
    FAILED: Error in metadata: MetaException(message:Got exception:
    org.apache.hadoop.security.AccessControlException Permission denied:
    user=root, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:205)
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:186)
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:135)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:4265)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkAncestorAccess(FSNamesystem.java:4236)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInternal(FSNamesystem.java:2628)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(FSNamesystem.java:2592)
    at
    org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mkdirs(NameNodeRpcServer.java:638)
    at
    org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.mkdirs(ClientNamenodeProtocolServerSideTranslatorPB.java:412)
    at
    org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java:42618)
    at
    org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:427)
    at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:916)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1692)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1688)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:396)
    at
    org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1232)
    at org.apache.hadoop.ipc.Server$Handler.run(Server.java:1686)
    )
    FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask


    --
    Mahesh Bhat

    --
    Mahesh Bhat
  • Vinod Chandrashekar at Sep 24, 2012 at 6:21 am
    Hey Guys,

    I'm facing the same problem too,

    While trying to run the Hive Query - It showed an error and said the
    namenode is in Safe mode.

    After removing the safe mode I tried running the same command, The below is
    error I got.

    hive> create table emp (name STRING, age STRING)
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
    STORED AS TEXTFILE;
    FAILED: Error in metadata: MetaException(message:Got exception:
    org.apache.hadoop.security.AccessControlException Permission denied:
    user=root, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x
    at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.
    check(FSPermissionChecker.java:205)
    at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.
    check(FSPermissionChecker.java:186)
    at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.
    checkPermission(FSPermissionChecker.java:135)
    at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.
    checkPermission(FSNamesystem.java:4265)
    at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.
    checkAncestorAccess(FSNamesystem.java:4236)
    at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.
    mkdirsInternal(FSNamesystem.java:2628)
    at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(
    FSNamesystem.java:2592)
    at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.
    mkdirs(NameNodeRpcServer.java:638)
    at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSi
    deTranslatorPB.mkdirs(ClientNamenodeProtocolServerSideTranslatorPB.java:412)
    at org.apache.hadoop.hdfs.protocol.proto.
    ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(
    ClientNamenodeProtocolProtos.java:42618)
    at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$
    ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:427)
    at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:916)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1692)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1688)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:396)
    at org.apache.hadoop.security.UserGroupInformation.doAs(
    UserGroupInformation.java:1232)
    at org.apache.hadoop.ipc.Server$Handler.run(Server.java:1686)
    )
    FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask

    Any thoughts

    Thanks
    Vinod

    On Sunday, September 23, 2012 1:15:27 PM UTC+5:30, Mahesh Bhat wrote:

    Guys i have attached an error can you please look in to it and suggest....


    On 9/23/12, Mahesh Bhat <mahes...@gmail.com <javascript:>> wrote:
    hive> create table abc(name STRING, age STRING)
    row format delimited fields terminated by '/t'
    stored as textfile;
    FAILED: Error in metadata: MetaException(message:Got exception:
    org.apache.hadoop.security.AccessControlException Permission denied:
    user=root, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:205)
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:186)
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:135)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:4265)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkAncestorAccess(FSNamesystem.java:4236)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInternal(FSNamesystem.java:2628)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(FSNamesystem.java:2592)
    at
    org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mkdirs(NameNodeRpcServer.java:638)
    at
    org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.mkdirs(ClientNamenodeProtocolServerSideTranslatorPB.java:412)
    at
    org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java:42618)
    at
    org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:427)
    at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:916)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1692)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1688)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:396)
    at
    org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1232)
    at org.apache.hadoop.ipc.Server$Handler.run(Server.java:1686)
    )
    FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask


    --
    Mahesh Bhat

    --
    Mahesh Bhat


    SessionStart SESSION_ID="hue_201209230740" TIME="1348386016231"
    QueryStart QUERY_STRING="create table affine ( name STRING, age STRING)
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '/t' stored as textfile"
    QUERY_ID="hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe"
    TIME="1348386016266"
    Counters
    plan="{"queryId":"hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe","queryType":null,"queryAttributes":{"queryString":"create
    table affine ( name STRING, age STRING) ROW FORMAT DELIMITED FIELDS
    TERMINATED BY '/t' stored as
    textfile"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"false","started":"false"}],"done":"false","started":"false"}],"done":"false","started":"true"}"
    TIME="1348386016266"
    TaskStart TASK_NAME="org.apache.hadoop.hive.ql.exec.DDLTask"
    TASK_ID="Stage-0"
    QUERY_ID="hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe"
    TIME="1348386016267"
    Counters
    plan="{"queryId":"hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe","queryType":null,"queryAttributes":{"queryString":"create
    table affine ( name STRING, age STRING) ROW FORMAT DELIMITED FIELDS
    TERMINATED BY '/t' stored as
    textfile"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"false","started":"true"}],"done":"false","started":"true"}],"done":"false","started":"true"}"
    TIME="1348386016267"
    Counters
    plan="{"queryId":"hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe","queryType":null,"queryAttributes":{"queryString":"create
    table affine ( name STRING, age STRING) ROW FORMAT DELIMITED FIELDS
    TERMINATED BY '/t' stored as
    textfile"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"true","started":"true"}],"done":"true","started":"true"}],"done":"false","started":"true"}"
    TIME="1348386016311"
    QueryEnd QUERY_STRING="create table affine ( name STRING, age STRING) ROW
    FORMAT DELIMITED FIELDS TERMINATED BY '/t' stored as textfile"
    QUERY_ID="hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe"
    QUERY_NUM_TASKS="0" TIME="1348386016312"
    --


    This email and any files transmitted with it are confidential and intended
    solely for the use of the individual or entity to whom they are addressed.
    Please notify the sender immediately by e-mail if you have received this
    e-mail by mistake and delete this e-mail from your system. You are also
    notified that disclosing, copying, distributing or taking any action in
    reliance on the contents of this information is strictly prohibited.
  • Joey Echeverria at Sep 24, 2012 at 12:51 pm
    Sorry, I sent this reply but it didn't go to the whole list:

    I think the problem is that you're missing the /user/root directory.

    Try running this:

    sudo -u hdfs hadoop fs -mkdir /user/root
    sudo -u hdfs hadoop fs -chown root /user/root

    and then try your query again.

    -Joey

    On Mon, Sep 24, 2012 at 2:21 AM, Vinod Chandrashekar
    wrote:
    Hey Guys,

    I'm facing the same problem too,

    While trying to run the Hive Query - It showed an error and said the
    namenode is in Safe mode.

    After removing the safe mode I tried running the same command, The below is
    error I got.

    hive> create table emp (name STRING, age STRING)
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
    STORED AS TEXTFILE;
    FAILED: Error in metadata: MetaException(message:Got exception:
    org.apache.hadoop.security.AccessControlException Permission denied:
    user=root, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:205)
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:186)
    at
    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:135)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:4265)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkAncestorAccess(FSNamesystem.java:4236)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInternal(FSNamesystem.java:2628)
    at
    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(FSNamesystem.java:2592)
    at
    org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mkdirs(NameNodeRpcServer.java:638)
    at
    org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.mkdirs(ClientNamenodeProtocolServerSideTranslatorPB.java:412)
    at
    org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java:42618)
    at
    org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:427)
    at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:916)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1692)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1688)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:396)
    at
    org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1232)
    at org.apache.hadoop.ipc.Server$Handler.run(Server.java:1686)
    )
    FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask

    Any thoughts

    Thanks
    Vinod

    On Sunday, September 23, 2012 1:15:27 PM UTC+5:30, Mahesh Bhat wrote:

    Guys i have attached an error can you please look in to it and suggest....


    On 9/23/12, Mahesh Bhat wrote:
    hive> create table abc(name STRING, age STRING)
    row format delimited fields terminated by '/t'
    stored as textfile;
    FAILED: Error in metadata: MetaException(message:Got exception:
    org.apache.hadoop.security.AccessControlException Permission denied:
    user=root, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x
    at

    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:205)
    at

    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:186)
    at

    org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:135)
    at

    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:4265)
    at

    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkAncestorAccess(FSNamesystem.java:4236)
    at

    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInternal(FSNamesystem.java:2628)
    at

    org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(FSNamesystem.java:2592)
    at

    org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mkdirs(NameNodeRpcServer.java:638)
    at

    org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.mkdirs(ClientNamenodeProtocolServerSideTranslatorPB.java:412)
    at

    org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java:42618)
    at

    org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:427)
    at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:916)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1692)
    at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1688)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:396)
    at

    org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1232)
    at org.apache.hadoop.ipc.Server$Handler.run(Server.java:1686)
    )
    FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask


    --
    Mahesh Bhat

    --
    Mahesh Bhat


    SessionStart SESSION_ID="hue_201209230740" TIME="1348386016231"
    QueryStart QUERY_STRING="create table affine ( name STRING, age STRING)
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '/t' stored as textfile"
    QUERY_ID="hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe"
    TIME="1348386016266"
    Counters
    plan="{"queryId":"hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe","queryType":null,"queryAttributes":{"queryString":"create
    table affine ( name STRING, age STRING) ROW FORMAT DELIMITED FIELDS
    TERMINATED BY '/t' stored as
    textfile"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"false","started":"false"}],"done":"false","started":"false"}],"done":"false","started":"true"}"
    TIME="1348386016266"
    TaskStart TASK_NAME="org.apache.hadoop.hive.ql.exec.DDLTask"
    TASK_ID="Stage-0"
    QUERY_ID="hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe"
    TIME="1348386016267"
    Counters
    plan="{"queryId":"hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe","queryType":null,"queryAttributes":{"queryString":"create
    table affine ( name STRING, age STRING) ROW FORMAT DELIMITED FIELDS
    TERMINATED BY '/t' stored as
    textfile"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"false","started":"true"}],"done":"false","started":"true"}],"done":"false","started":"true"}"
    TIME="1348386016267"
    Counters
    plan="{"queryId":"hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe","queryType":null,"queryAttributes":{"queryString":"create
    table affine ( name STRING, age STRING) ROW FORMAT DELIMITED FIELDS
    TERMINATED BY '/t' stored as
    textfile"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"true","started":"true"}],"done":"true","started":"true"}],"done":"false","started":"true"}"
    TIME="1348386016311"
    QueryEnd QUERY_STRING="create table affine ( name STRING, age STRING) ROW
    FORMAT DELIMITED FIELDS TERMINATED BY '/t' stored as textfile"
    QUERY_ID="hue_20120923074040_4d6b12ab-1437-440f-9112-30f203410bbe"
    QUERY_NUM_TASKS="0" TIME="1348386016312"

    This email and any files transmitted with it are confidential and intended
    solely for the use of the individual or entity to whom they are addressed.
    Please notify the sender immediately by e-mail if you have received this
    e-mail by mistake and delete this e-mail from your system. You are also
    notified that disclosing, copying, distributing or taking any action in
    reliance on the contents of this information is strictly prohibited.


    --
    Joey Echeverria
    Principal Solutions Architect
    Cloudera, Inc.
  • Vinod Chandrashekar at Sep 26, 2012 at 12:13 pm
    Hi All,

    I tried running an hive query and ended up with this .. Whats the problem
    its facing and how do I fix this..

    hive> create table employee (name STRING, age STRING)
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '/t'
    stored as textfile;
    FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException:
    Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The
    driver has not received any packets from the server.
    NestedThrowables:
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
    link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The
    driver has not received any packets from the server.
    FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask

    Thanks

    --


    This email and any files transmitted with it are confidential and intended
    solely for the use of the individual or entity to whom they are addressed.
    Please notify the sender immediately by e-mail if you have received this
    e-mail by mistake and delete this e-mail from your system. You are also
    notified that disclosing, copying, distributing or taking any action in
    reliance on the contents of this information is strictly prohibited.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedSep 23, '12 at 7:22a
activeSep 26, '12 at 12:13p
posts5
users3
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase