至于说性能，如果你确定后台是Hive，大致来讲可以通过external table, partition and/or bucket, parquet +snappy, analyze, etc to improve performance. But again, theses are something supposed to be done by dba/architect, from the data consumers perspective, nothing but sql.