dawsongzhao
dawsongzhao
snappy> ```sql with e as ( select b.handle_time as date, c.pig_type from ihp_farm_harmless a left join ihp_harmless b on a.id = b.origin_id left join ihp_harmless_detail c on b.id = c.harmless_id...
```shell snappy> select * from dev_bigdata_bio_antiasf.ods_bio_car_archives; ERROR 42000: (SQLState=42000 Severity=20000) (Server=hdfs06-dev.yingzi.com/172.19.101.81[1527] Thread=ThriftProcessor-7) Syntax error or analysis exception: Table or view not found: `DEV_BIGDATA_BIO_ANTIASF`.`ODS_BIO_CAR_ARCHIVES`;; 'Project [*] +- 'UnresolvedRelation `DEV_BIGDATA_BIO_ANTIASF`.`ODS_BIO_CAR_ARCHIVES` snappy> create...
Does XSQL have plan to support Delta lake or Spark Structed Streaming?
when I run below code on my macbook,everything is Ok; ```python helper = WxMsgHelper() current_date = datetime.datetime.now().strftime('%Y-%m-%d') for user_name in user_tables_map: df1 = df[df.createby.str.contains(fr'\b{user_name}\b', regex=True, case=False)] if len(df1) > 10:...
How to compile from source code? How to use it?