Question: ```
CREATE TABLE
  mydataset.newtable (transaction_id INT64, transaction_date DATE)
PARTITION BY
  transaction_date
AS SELECT transaction_id, transaction_date FROM mydataset.mytable

```

The docs don't specify whether the PARTITION BY clause supports "required".

Answer: 
Solved it finally by displaying more logs on the error message.
The key action is to update Gradle in my project level build.gradle file,

I changed:

```
classpath 'com.android.tools.build:gradle:4.0.2'

```

To:

```
classpath 'com.android.tools.build:gradle:4.2.1'

```
**first** go to your pc dir wich android sdk is installed

```
in my pc dir is ->  C:\Users\lotka-pc\AppData\Local\Android\Sdk\cmake

```

and delete the older version

**second** in your gradle file **module** you should change the version of cmake

```
    externalNativeBuild {
    cmake {
        path file('src/main/cpp/CMakeLists.txt')
        version '3.18.1'
    }
}

```

**third** - you should check dir

```
src/main/cpp/CmakeList.txt 

```

and check the version

```
cmake_minimum_required(VERSION 3.10.2)

```

these will work :)