Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

WARNING 3673: Invalid hint identifier 'DIRECT'

I saw some disk spills using this command SELECT analyze_constraints('schema1.table1'); I hence tried to change to using SELECT /+DIRECT/ analyze_constraints('schema1.table1') via shell script. if I run directly it runs normally . but when I run via shell script get error WARNING 3673: Invalid hint identifier 'DIRECT' .Is this issue with shell script or direct not allowed for analyze_constraints or even analyze_statistics.

Comments

  • The DIRECT hint is only used for DML statements: INSERT, UPDATE, DELETE, MERGE. And calling a function like ANALYZE_CONSTRAINTS() is not a DML statement - hence the hint is not valid in this context.

    Analyzing constraints can be very memory intensive on bigger tables, you might just have to live with the disk spill.

    Possible workarounds could be to use staging tables for the smaller daily delta, and analyze the constraints there, before integrating into the big table.

  • thanks marcothesane for instant response. that's what I thought .

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.