You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/11/18 05:04:10 UTC
[jira] [Commented] (TRAFODION-1634) Update stats on Hive tables is
slow
[ https://issues.apache.org/jira/browse/TRAFODION-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15010179#comment-15010179 ]
Suresh Subbiah commented on TRAFODION-1634:
-------------------------------------------
update stats on hive tables is rather slow.
>From offender we can see that it uses ‘INSERT INTO’ instead of ‘UPSERT USING LOAD INTO’ as update stats on trafodion tables.
2015-11-18 10:54:50.804258 115 MXID11004011308212314542474737244000000000206U3333300_342_SQL_CUR_2 EXECUTE "update statistics for table HIVE.HIVE.ANLC on every column, (MANDT, BUKRS, ANLN1), (BUKRS, ANLN1),(KAAFA), (GJAHR, AFABE), (MANDT, BUKRS, ANLN1, ANLN2) sample
2015-11-18 10:54:50.804258 93 MXID11004011534212314575175750421000000000106U3333300_127_127 OPEN "INSERT INTO TRAFODION."_HIVESTATS_".SQLMX_6537057301866804643_1447815193_264493 SELECT * FROM HIVE.HIVE.ANLC <<+ cardinality 2.439319e+07 >> SAMPLE RANDOM 0.999997 PERCENT FOR READ UNCOMMITTED ACCESS
> Update stats on Hive tables is slow
> -----------------------------------
>
> Key: TRAFODION-1634
> URL: https://issues.apache.org/jira/browse/TRAFODION-1634
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Suresh Subbiah
> Assignee: Suresh Subbiah
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)