hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chunling Wang <wangchunlin...@126.com>
Subject Re: Can not using PXF and HCatalog to query Hive
Date Tue, 21 Mar 2017 14:43:33 GMT
Thanks Alex, it works well!

Regards, Chunling

> 在 2017年3月21日,01:20,Alex (Oleksandr) Diachenko <odiachenko@pivotal.io>
写道:
> 
> Hi,
> 
> Could you please share your pxf-profiles.xml config file?
> The root cause of that error could be if your px-profiles is not up-to-date.
> You can update your config with latest version of pxf-profiles -
> https://github.com/apache/incubator-hawq/blob/master/pxf/pxf-service/src/main/resources/pxf-profiles-default.xml
> and
> it should work.
> Please let me know if it helped.
> 
> Regards, Alex.
> 
> On Mon, Mar 20, 2017 at 3:57 AM, Chunling Wang <wangchunling14@126.com>
> wrote:
> 
>> Hi all,
>> Now I have some problems when query Hive using PXF and HCatalog. I create
>> an AWS agent installing HAWQ and Hive with Ambari. When I try to access
>> table data in Hive through PXF, I get the error showing as below:
>> 
>> postgres=# select * from hcatalog.default.a;
>> ERROR:  remote component error (500) from '127.0.0.1:51200':  type
>> Exception report   message   Unable to find output format by given class
>> name: null    description   The server encountered an internal error that
>> prevented it from fulfilling this request.    exception
>> org.apache.hawq.pxf.api.UnsupportedTypeException: Unable to find output
>> format by given class name: null (libchurl.c:897)
>> postgres=# \d+ hcatalog.default.a
>> ERROR:  remote component error (500) from '127.0.0.1:51200':  type
>> Exception report   message   Unable to find output format by given class
>> name: null    description   The server encountered an internal error that
>> prevented it from fulfilling this request.    exception
>> org.apache.hawq.pxf.api.UnsupportedTypeException: Unable to find output
>> format by given class name: null (libchurl.c:897)
>> 
>> But I can get the detail table messages through ‘\d hcatalog.default.*’:
>> postgres=# \d+ hcatalog.default.*
>> PXF Hive Table "default.a"
>> Column | Type | Source type
>> --------+------+-------------
>> id     | int4 | int
>> 
>> PXF Hive Table "default.b"
>> Column | Type | Source type
>> --------+------+-------------
>> id     | int4 | int
>> 
>>   PXF Hive Table "default.sales_info"
>>      Column      |  Type  | Source type
>> ------------------+--------+-------------
>> number_of_orders | int4   | int
>> total_sales      | float8 | double
>> month            | text   | string
>> location         | text   | string
>> 
>> The table in Hive is showing below:
>> $ sudo -u hive hive
>> Logging initialized using configuration in file:/etc/hive/2.5.3.0-37/0/
>> hive-log4j.properties
>> hive> show tables;
>> OK
>> a
>> b
>> sales_info
>> Time taken: 1.443 seconds, Fetched: 3 row(s)
>> hive>
>> 
>> And I have tried to access HDFS file data through creating external table
>> in HAWQ and using PXF. It worked well.
>> So do you meet this error before and have any ideas to resolve it?
>> 
>> Thanks a lot!
>> 
>> Chunling
>> 
>> 
>> 
>> 



Mime
View raw message