//echo '<div class="span10">';
echo '<br />' . $_GET['database'] . '<i class=icon-backward></i> <a href=dbStructure.php?database=' . $_GET['database'] . ' target="right">' . $lang['back'] . '</a><br /><br />';
include_once 'templates/sql_query_navi.html';
echo "<br /><br />";
$transport = new TSocket(HOST, PORT);
$protocol = new TBinaryProtocol($transport);
$client = new ThriftHiveClient($protocol);
$transport->open();
$sql = 'use `' . $_GET['database'] . '`';
//echo $sql.'<br /><br />';
$client->execute($sql);
//$client->fetchOne();
$sql = 'desc formatted ' . $_GET['table'];
$client->execute($sql);
$array_desc_table = $client->fetchAll();
$array_desc_table_1 = $etc->GetTableDetail($array_desc_table, "1");
$array_desc_table_4 = @$etc->GetTableDetail($array_desc_table, "4");
if ($array_desc_table_4[0] != "") {
$array_desc_desc = @array_merge($array_desc_table_1, $array_desc_table_4);
} else {
$array_desc_desc = $array_desc_table_1;
}
//get table description and explode the desc into a multi-dimensional array
//��ȡ��˵�����������ά����$array_desc_desc
$i = 0;
while ('' != @$array_desc_desc[$i]) {
$array_desc = explode(' ', $array_desc_desc[$i]);
$array_desc_desc_col['name'][$i] = trim($array_desc[0]);
$array_desc_desc_col['type'][$i] = trim($array_desc[1]);
$array_desc_desc_col['comment'][$i] = trim($array_desc[2]);
$i++;
die($lang['dieDatabaseChoose']);
} else {
$transport = new TSocket(HOST, PORT);
$protocol = new TBinaryProtocol($transport);
$client = new ThriftHiveClient($protocol);
$transport->open();
$client->execute('use ' . $_GET['database']);
echo '<div class="container">';
echo '<div class="span10">';
if (!@$_GET['table']) {
die($lang['dieTableChoose']);
} else {
$sql = "desc formatted " . $_GET['table'];
$client->execute($sql);
$arr = $client->fetchAll();
$arr = $etc->GetTableDetail($arr, "2");
$j = 0;
foreach ($arr as $k => $v) {
$array_desc = explode(':', $v);
$array_desc_desc['key'][$j] = trim($array_desc[0]);
$array_desc_desc['value'][$j] = trim($array_desc[1]);
if ($array_desc_desc['value'][$j] == 'MANAGED_TABLE' || $array_desc_desc['value'][$j] == 'INDEX_TABLE') {
$tmp['key'] = $array_desc_desc['key'][$j];
$tmp['value'] = $array_desc_desc['value'][$j];
}
$j++;
}
if ($tmp['value'] != "MANAGED_TABLE" && $tmp['value'] != "INDEX_TABLE") {
die('<script>alert("' . $lang['notExternalTable'] . '");history.back();</script>');
} else {
echo "<a href=dbStructure.php?database=" . $_GET['database'] . "><i class=icon-backward></i>" . $lang['back'] . "</a><br><br>";
