> So transactional tables only work with hdfs. Thanks for the confirmation > Elliot.
No, that's not what said. Streaming ingest into transactional tables requires strong filesystem consistency and a flush-to-remote operation (hflush). S3 supports neither of those things and HDFS is not the only filesystem which has both those features. For eg. see AdlFsOutputStream.java#L38. Cheers, Gopal