First page Back Continue Last page Image

Impala Code Example

https://docs.cloudera.com/documentation/enterprise/5-8-x/topics/impala_tutorial.html

[localhost:21000] > create database experiments;

[localhost:21000] > show databases;

+--------------------------+

| name |

+--------------------------+

| _impala_builtins |

| ctas |

| d1 |

| d2 |

| d3 |

| default |

| experiments |

| explain_plans |

| external_table |

| file_formats |

| tpc |

+--------------------------+

[localhost:21000] > show databases like 'exp*';

+---------------+

| name |

+---------------+

| experiments |

| explain_plans |

+---------------+

[localhost:21000] > show tables;

+------------------------+

| name |

+------------------------+

| city |

| customer |

| customer_address |

| customer_demographics |

| household_demographics |

| item |

| promotion |

| store |

| store2 |

| store_sales |

| t1 |

| ticket_view |

| time_dim |

| tpc_tables |

+------------------------+