Labkey pivot query limit | Jon (LabKey DevOps) | 2016-06-16 00:51 |
Status: Closed | ||
Hi Kristen, Unfortunately, this is something that is outside of our control since this is a database limit with Postgres. You could potentially have the data split between two tables to where one table has some columns and another table has the rest, then use a join to get the two tables together in a single query, but even that query would be subjected to the 1664 column limit as well since it is a postgresql limitation. The only other possibility is to switch databases and use a Microsoft SQL database instead. According to Microsoft's website, a non-wide table would only allow 1024 columns, but a wide table would be able to take 30,000 and their select statements can pull in 4069 columns. https://msdn.microsoft.com/en-us/library/ms143432.aspx Regards, Jon |
||