[
https://issues.apache.org/jira/browse/HAWQ-1547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16252770#comment-16252770
]
Lei Chang commented on HAWQ-1547:
---------------------------------
Looks a good improvement.
> 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
> hcatalog.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
> Line: 1
> Thanks
> Grant
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
