https://community.databricks.com/t5/data-engineering/some-of-the-limitation-i-see-in-docs-of-photon-until-now-july/m-p/17800#M11747 <P>Some of the limitation I see In docs of photon until now july 2021 is </P><P></P><UL><LI>Works on Delta and Parquet tables only for both read and write.</LI><LI>Does not support the following data types:<UL><LI>Map</LI><LI>Array</LI></UL></LI><LI>Does not support window and sort operators</LI><LI>Does not support Spark Structured Streaming.</LI><LI>Does not support UDFs.</LI><LI>Not expected to improve operations bottlenecked by network or scan I/O.</LI><LI>Not expected to improve short-running queries (&lt;2 seconds), for example, against small data.</LI></UL><P></P><P>Any idea is this limitations going to be removed in future ,I think the most important one is third and fifth one that we are looking at to get faster performance</P> Mon, 28 Jun 2021 13:26:25 GMT User16826994223 2021-06-28T13:26:25Z https://community.databricks.com/t5/data-engineering/some-of-the-limitation-i-see-in-docs-of-photon-until-now-july/m-p/17800#M11747 <P>Some of the limitation I see In docs of photon until now july 2021 is </P><P></P><UL><LI>Works on Delta and Parquet tables only for both read and write.</LI><LI>Does not support the following data types:<UL><LI>Map</LI><LI>Array</LI></UL></LI><LI>Does not support window and sort operators</LI><LI>Does not support Spark Structured Streaming.</LI><LI>Does not support UDFs.</LI><LI>Not expected to improve operations bottlenecked by network or scan I/O.</LI><LI>Not expected to improve short-running queries (&lt;2 seconds), for example, against small data.</LI></UL><P></P><P>Any idea is this limitations going to be removed in future ,I think the most important one is third and fifth one that we are looking at to get faster performance</P> Mon, 28 Jun 2021 13:26:25 GMT https://community.databricks.com/t5/data-engineering/some-of-the-limitation-i-see-in-docs-of-photon-until-now-july/m-p/17800#M11747 User16826994223 2021-06-28T13:26:25Z