상황 : HDP(Hortonworks Data Platform) 환경의 HUE에서 Hcatalog 의 table describe 조회시 오류 발생
Ambari의 Hive > Configs >  Custom hiveserver2-site 에 hive.server2.enable.impersonation 속성 추가

사용자 삽입 이미지










에러 내용
Error getting table description

Traceback (most recent call last): File "/usr/lib/hue/apps/hcatalog/src/hcatalog/views.py",
 line 149,
 in describe_table table_desc_extended = HCatClient(request.user.username).describe_table_extended(table,
 db=database) File "/usr/lib/hue/apps/hcatalog/src/hcatalog/hcat_client.py",
 line 142,
 in describe_table_extended raise Exception(error) Exception: Could not get table description (extended): {"statement":"use ing_db; show table extended like a;",
"error":"unable to show table: a",
"exec":{"stdout":"2015-09-10 09:08:23,
232 WARN - [main:] ~ HiveConf of name hive.server2.enable.impersonation does not exist (HiveConf:2762)\n{\"columns\":[{\"name\":\"a\",
\"type\":\"int\"},
{\"name\":\"b\",
\"type\":\"int\"}],
\"tableInfo\":{\"tableName\":\"a\",
\"dbName\":\"ing_db\",
\"owner\":\"hive\",
\"createTime\":1441780493,
\"lastAccessTime\":0,
\"retention\":0,
\"sd\":{\"cols\":[{\"name\":\"a\",
\"type\":\"int\",
\"comment\":null,
\"setName\":true,
\"setType\":true,
\"setComment\":false},
{\"name\":\"b\",
\"type\":\"int\",
\"comment\":null,
\"setName\":true,
\"setType\":true,
\"setComment\":false}],
\"location\":\"hdfs://hdfs.sunshiny:8020/apps/hive/warehouse/ing_db.db/a\",
\"inputFormat\":\"org.apache.hadoop.mapred.TextInputFormat\",
\"outputFormat\":\"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat\",
\"compressed\":false,
\"numBuckets\":-1,
\"serdeInfo\":{\"name\":null,
\"serializationLib\":\"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe\",
\"parameters\":{\"serialization.format\":\"1\"},
\"parametersSize\":1,
\"setParameters\":true,
\"setName\":false,
\"setSerializationLib\":true},
\"bucketCols\":[],
\"sortCols\":[],
\"parameters\":{},
\"skewedInfo\":{\"skewedColNames\":[],
\"skewedColValues\":[],
\"skewedColValueLocationMaps\":{},
\"skewedColNamesSize\":0,
\"skewedColNamesIterator\":[],
\"setSkewedColNames\":true,
\"skewedColValuesSize\":0,
\"skewedColValuesIterator\":[],
\"setSkewedColValues\":true,
\"skewedColValueLocationMapsSize\":0,
\"setSkewedColValueLocationMaps\":true},
\"storedAsSubDirectories\":false,
\"colsSize\":2,
\"parametersSize\":0,
\"setParameters\":true,
\"colsIterator\":[{\"name\":\"a\",
\"type\":\"int\",
\"comment\":null,
\"setName\":true,
\"setType\":true,
\"setComment\":false},
{\"name\":\"b\",
\"type\":\"int\",
\"comment\":null,
\"setName\":true,
\"setType\":true,
\"setComment\":false}],
\"setCols\":true,
\"setLocation\":true,
\"setInputFormat\":true,
\"setOutputFormat\":true,
\"setCompressed\":true,
\"setNumBuckets\":true,
\"setSerdeInfo\":true,
\"bucketColsSize\":0,
\"bucketColsIterator\":[],
\"setBucketCols\":true,
\"sortColsSize\":0,
\"sortColsIterator\":[],
\"setSortCols\":true,
\"setSkewedInfo\":true,
\"setStoredAsSubDirectories\":true},
\"partitionKeys\":[],
\"parameters\":{\"totalSize\":\"8\",
\"numRows\":\"2\",
\"rawDataSize\":\"6\",
\"COLUMN_STATS_ACCURATE\":\"true\",
\"numFiles\":\"2\",
\"transient_lastDdlTime\":\"1441780528\"},
\"viewOriginalText\":null,
\"viewExpandedText\":null,
\"tableType\":\"MANAGED_TABLE\",
\"privileges\":null,
\"temporary\":false,
\"setDbName\":true,
\"setCreateTime\":true,
\"setLastAccessTime\":true,
\"setSd\":true,
\"parametersSize\":6,
\"setParameters\":true,
\"setTableName\":true,
\"setPrivileges\":false,
\"setOwner\":true,
\"setRetention\":true,
\"partitionKeysSize\":0,
\"partitionKeysIterator\":[],
\"setPartitionKeys\":true,
\"setViewOriginalText\":false,
\"setViewExpandedText\":false,
\"setTableType\":true,
\"setTemporary\":false}}\t \t \n",
"stderr":"which: no /usr/hdp/2.3.0.0-2557//hadoop/bin/hadoop.distro in ((null))\ndirname: missing operand\nTry `dirname --help' for more information.\nWARNING: Use \"yarn jar\" to launch YARN applications.\nOK\nTime taken: 1.078 seconds\nOK\nTime taken: 0.684 seconds\n",
"exitcode":0}} (error 500)




※ 위 내용은, 여러 자료를 참고하거나 제가 주관적으로 정리한 것입니다.
   잘못된 정보나 보완이 필요한 부분을, 댓글 또는 메일로 보내주시면 많은 도움이 되겠습니다.

"BigData / HUE" 분류의 다른 글

Hue - HDP(Hortonworks Data Platform)환경 HUE Install (0)2015/09/10
09 10, 2015 18:00 09 10, 2015 18:00


Trackback URL : http://develop.sunshiny.co.kr/trackback/1030

Leave a comment

« Previous : 1 : ... 19 : 20 : 21 : 22 : 23 : 24 : 25 : 26 : 27 : ... 648 : Next »

Recent Posts

  1. HDFS - Python Encoding 오류 처리
  2. HP - Vertica ROS Container 관련 오류...
  3. HDFS - Hive 실행시 System Time 오류
  4. HP - Vertica 사용자 쿼리 이력 테이블...
  5. Client에서 HDFS 환경의 데이터 처리시...

Recent Comments

  1. Right away I am ready to do my bre... 골목게임 11 17,
  2. Terrific article! That is the type... 선릉야구장 11 16,
  3. Yes! Finally someone writes about /. / 11 16,
  4. Круто, круто! Некот... карточные игры на... 11 13,
  5. 안녕하세요^^ 배그핵

Recent Trackbacks

  1. master djs bozeman master djs bozeman %M
  2. wedding dj bozeman mt wedding dj bozeman mt 17 11
  3. joes dj bozeman joes dj bozeman 17 11
  4. Mysql - mysql 설치후 Character set... 멀고 가까움이 다르기 때문 %M

Calendar

«   11 2019   »
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

Bookmarks

  1. 위키피디아
  2. MysqlKorea
  3. 오라클 클럽
  4. API - Java
  5. Apache Hadoop API
  6. Apache Software Foundation
  7. HDFS 생태계 솔루션
  8. DNSBL - Spam Database Lookup
  9. Ready System
  10. Solaris Freeware
  11. Linux-Site
  12. 윈디하나의 솔라나라

Site Stats

TOTAL 2755911 HIT
TODAY 153 HIT
YESTERDAY 638 HIT