CopyToTempView support cache for improving perfermance

when user in sparksql session mode，can not cache tempview for read_optimized or snapshot，so we need support it for improment sql in query or join scene