Flex Tables

Discussion List

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

  Answered ankitdm 3.3K 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.5K views 2 comments 0 points Most recent by greyofthedawn December 2023General Discussion
• 
  Extract JSON Data From Regular Table

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

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

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

  robann 8.8K 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.7K 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 15.9K views 6 comments 0 points Most recent by jacksonwill September 2022General Discussion
• 
  Specifying length of VARCHAR

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

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

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

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

  Answered ✓ rajatpaliwal86 26.6K 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.7K views 2 comments 0 points Most recent by Jim_Knicely April 2020General Discussion
• 
  cannot drop text index in Vertica

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

  Answered sandeepdeva 18.9K 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.1K views 1 comment 0 points Most recent by Ariel_Cary April 2020General Discussion
• 
  vertica copy command bug?

  Answered ✓ rajatpaliwal86 41.2K 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.6K views 4 comments 0 points Most recent by rajatpaliwal86 February 2020General Discussion
• 
  order by on JOIN of tables is very slow

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

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

  mc123 6.9K 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