hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Grant Krieger (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1547) Increase default table name length from 64 to 128 to match Hive
Date Fri, 10 Nov 2017 12:22:00 GMT
Grant Krieger created HAWQ-1547:
-----------------------------------

             Summary: Increase default table name length from 64 to 128 to match Hive
                 Key: HAWQ-1547
                 URL: https://issues.apache.org/jira/browse/HAWQ-1547
             Project: Apache HAWQ
          Issue Type: Improvement
          Components: Unknown
            Reporter: Grant Krieger
            Assignee: Radar Lei


Hi,

Would it be possible to increase incubator-hawq/src/include/pg_config_manual.h property default
NAMEDATALEN from 64 to 128. 

This hopefully will allow one to be able to read Hive tables from Hawq larger than 64 by default
without having to change this setting when compiling for downstream systems. It will also
allow for equivalently name Hawq tables.

Does anyone foresee performance challenges with the increase? 

See problem below:

In hive

CREATE TABLE default.test123456789123456789123456789123456789123456789123456789123456789123456789123456789test
( 
	rtlymth	int, 
	rtly   	int)

STORED AS ORC

in Hawq

select * from default.test123456789123456789123456789123456789123456789123456789123456789123456789123456789test

ERROR: remote component error (500) from '127.0.0.1:51200':  type  Exception report   message
  NoSuchObjectException(message:default.test12345678912345678912345678912345678912345678912345678912345
table not found)    description   The server encountered an internal error that prevented
it from fulfilling this request.    exception   javax.servlet.ServletException: NoSuchObjectException(message:default.test12345678912345678912345678912345678912345678912345678912345
table not found) (libchurl.c:897)
  Position: 15

Thanks

Grant



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message