Skip to main content

License usage for external table using HCatalog/Hive access

  • November 14, 2017
  • 1 reply
  • 4 views
Kaito
Forum|alt.badge.img+2
  • Kaito
  • Participating Frequently

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,

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • November 14, 2017

    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?

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement