Flex Tables

Discussion List

• 
  Is there an option to add a column alias to the table definition

  Answered ankitdm 3.5K views 2 comments 0 points Most recent by mosheg December 2023General Discussion
• 
  How to put json with array values into varchar columns

  Answered ✓ greyofthedawn 3.8K views 2 comments 0 points Most recent by greyofthedawn December 2023General Discussion
• 
  Extract JSON Data From Regular Table

  Answered bmurrell 2.6K views 1 comment 0 points Most recent by bmurrell October 2023General Discussion
• 
  Populating Flex table Materialized columns from current data in __raw__

  robann 2.9K views 1 comment 0 points Most recent by Ariel_Cary May 2023General Discussion
• 
  Flex table virtual column using a substring

  Answered bmurrell 4.7K views 2 comments 0 points Most recent by bmurrell May 2023General Discussion
• 
  Selecting a wildcard of virtual columns from a flex table

  robann 9.1K views 4 comments 0 points Most recent by robann April 2023General Discussion
• 
  MAPTOSTRING turns JSON arrays into objects keyed by array index and erases types

  Answered raayan0 8.9K views 3 comments 0 points Most recent by Sergey_Cherepan_1 November 2022General Discussion
• 
  What are the main advantages of using Vertica flex tables?

  Answered ✓ retheeshravi 16.4K views 6 comments 0 points Most recent by jacksonwill September 2022General Discussion
• 
  Specifying length of VARCHAR

  Answered Pieter_Sheth-Vo 25.1K views 8 comments 0 points Most recent by vivekbarad December 2020General Discussion
• 
  Hybrid Flex table performance vs standard table

  Answered rajatpaliwal86 12.2K views 4 comments 0 points Most recent by Pieter_Sheth-Vo December 2020General Discussion
• 
  Flex table view grant error

  Answered levkiss 11.9K views 4 comments 0 points Most recent by mosheg October 2020General Discussion
• 
  flex table to devide into partitions

  Answered maks 4.2K views 1 comment 0 points Most recent by sahil_kumar May 2020General Discussion
• 
  Fast bulkload for flex tables

  Answered ✓ rajatpaliwal86 27.2K views 10 comments 1 point Most recent by rajatpaliwal86 May 2020Product Feedback
• 
  Does vertica text index creation needs X Exclusive lock on the source table

  Answered ✓ rajatpaliwal86 10.9K views 2 comments 0 points Most recent by Jim_Knicely April 2020General Discussion
• 
  cannot drop text index in Vertica

  Answered ✓ rajatpaliwal86 6.8K views 2 comments 1 point Most recent by rajatpaliwal86 April 2020Product Feedback
• 
  Flex table interprets version string as a date

  Answered sandeepdeva 19.4K views 7 comments 0 points Most recent by Ariel_Cary April 2020General Discussion
• 
  How to fix multiple table declaration after materialize_flextable_columns?

  Answered Alexander_Magon 4.2K views 1 comment 0 points Most recent by Ariel_Cary April 2020General Discussion
• 
  vertica copy command bug?

  Answered ✓ rajatpaliwal86 42.3K views 16 comments 1 point Most recent by RasoolShaik February 2020Product Feedback
• 
  How to create text index on a flex table which has composite primary key

  Answered rajatpaliwal86 11.9K views 4 comments 0 points Most recent by rajatpaliwal86 February 2020General Discussion
• 
  order by on JOIN of tables is very slow

  Answered rajatpaliwal86 12.1K views 4 comments 0 points Most recent by rajatpaliwal86 January 2020Product Feedback
• 
  Handling array fields in Vertica

  Answered ✓ rajatpaliwal86 31.4K views 11 comments 0 points Most recent by rajatpaliwal86 November 2019General Discussion
• 
  JSON Column in Regular Table Not copying properly to Flex Table

  mc123 7K views 2 comments 0 points Most recent by twall July 2019General Discussion
• 
  JSON Column in Table not mapping correctly to flex table

  mc123 1.8K views 0 comments 0 points Most recent by mc123 July 2019General Discussion