Flex Tables

Discussion List

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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