title: Unable to read schema from given path: hdfs://...avsc
body: <p>I tried to create a hive table by the following steps:</p>
  
  <ol>
  <li>load data to hdfs using sqoop (done) </li>
  <li>sqoop created also a avsc file, which I uploaded to hdfs </li>
  <li>within hive I want to create a table using the following statement:</li>
  </ol>
  
  <p>Command:</p>
  
  <pre><code>CREATE EXTERNAL TABLE kontoauszug
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' 
  STORED AS 
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
  LOCATION 'hdfs:///user/tki/KONTOAUSZUG'
  TBLPROPERTIES ('avro.schema.url'='hdfs://m1.hdp2/user/tki/KONTOAUSZUG.avsc');
  </code></pre>
  
  <p>I am receiving the following error:</p>
  
  <pre><code>FAILED: Execution Error, return code 1 from
  org.apache.hadoop.hive.ql.exec.DDLTask. 
  java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException 
  Encountered AvroSerdeException determining schema. 
  Returning signal schema to indicate problem: Unable to read schema from given path: hdfs://m1.hdp2/user/tki/KONTOAUSZUG.avsc)
  </code></pre>
  
  <p>Does it mean, KONTOAUSZUG.avsc is not found? I crosschecked it's available.</p>
  
  <p>The content of it is:</p>
  
  <pre><code>[hadoop@m1 hive]$ cat KONTOAUSZUG.avsc 
  {
    "type" : "record",
    "name" : "KONTOAUSZUG",
    "doc" : "Sqoop import of KONTOAUSZUG",
    "fields" : [ {
      "name" : "FK_PROCESS_ID_INS",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "FK_PROCESS_ID_INS",
      "sqlType" : "2"
    }, {
      "name" : "FK_SOURCE_ID",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "FK_SOURCE_ID",
      "sqlType" : "2"
    }, {
      "name" : "SRC_STM_ID",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "SRC_STM_ID",
      "sqlType" : "2"
    }, {
      "name" : "FK_PROCESS_ID_UPD",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "FK_PROCESS_ID_UPD",
      "sqlType" : "2"
    }, {
      "name" : "BUCHUNGSDATUM",
      "type" : [ "null", "long" ],
      "default" : null,
      "columnName" : "BUCHUNGSDATUM",
      "sqlType" : "93"
    }, {
      "name" : "BUCHUNGSTEXT",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "BUCHUNGSTEXT",
      "sqlType" : "12"
    }, {
      "name" : "SOLL",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "SOLL",
      "sqlType" : "2"
    }, {
      "name" : "HABEN",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "HABEN",
      "sqlType" : "2"
    }, {
      "name" : "FK_KONTO_ID",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "FK_KONTO_ID",
      "sqlType" : "2"
    }, {
      "name" : "EINGABE_MANUELL_F",
      "type" : [ "null", "string" ],
      "default" : null,
      "columnName" : "EINGABE_MANUELL_F",
      "sqlType" : "2"
    } ],
    "tableName" : "KONTOAUSZUG"
  }
  </code></pre>