We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


License usage for external table using HCatalog/Hive access — Vertica Forum

License usage for external table using HCatalog/Hive access

KaitoKaito Employee
in General Discussion

Can I ask a Hadoop-related question to use external table using HCatalog/Hive?
I understand that　the only way to use EXTERNAL_TABLE_DETAILS for auditing a capacity of external tables. In HCatalog/Hive access environment, is it required to run SYNC_WITH_HCATALOG_SCHEMA? Or No needed?

https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/EXTERNAL_TABLE_DETAILS.htm?TocPath=SQL Reference Manual|Vertica%20System%20Tables|V_MONITOR%20Schema|_____26

Thanks in advance,

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    The SYNC_WITH_HCATALOG_SCHEMA function only syncs meta-data. You should't need to run it. The external tables already exist, so Vertica can compute the size of an external table counting all data found in the location specified by the external tables's COPY FROM clause.

    Are you not seeing the tables in EXTERNAL_TABLE_DETAILS?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...