if (!@$_GET['path']) { $path = "/"; } else { $path = $_GET['path']; } $etc = new Etc(); $sql = '"dfs -ls ' . $path . '"'; $LANG = 'export LANG=' . $env['lang_set'] . '; '; $HADOOP_HOME = 'export HADOOP_HOME=' . $env['hadoop_home'] . '; '; $HIVE_HOME = 'export HIVE_HOME=' . $env['hive_home'] . '; '; $JAVA_HOME = 'export JAVA_HOME=' . $env['java_home'] . '; '; $UDF = $env['udf'] != "" ? $env['udf'] : ""; $exec = $LANG . $HADOOP_HOME . $HIVE_HOME . $JAVA_HOME . $env['hive_home'] . '/bin/hive ' . $UDF . ' -e ' . $sql; $time = time(); $filename = $env['output_path'] . '/dfs_browse.' . $time . '.out'; $etc->NonBlockingRun($exec, $time, $filename, 1, $code); $list_arr = file($filename); echo '<div class="container">'; echo '<div class="span10">'; echo "<br>"; echo '<div class="btn-group">'; echo "<a class=\"btn btn-info\" href=fileBrowser.php?dir=/><i class=icon-eject></i>" . $lang['backToRoot'] . "</a>"; echo "<a class=\"btn btn-info\" href=javascript:history.back()><i class=icon-backward></i>" . $lang['back'] . "</a>"; echo "</div><br>"; echo "<table class=\"table table-bordered table-striped table-hover\">"; echo "<tr class=success>"; echo "<td>" . $lang['fileProperty'] . "</td>"; echo "<td>" . $lang['fileUser'] . "</td>"; echo "<td>" . $lang['fileGroup'] . "</td>"; echo "<td>" . $lang['filesize'] . "</td>"; echo "<td>" . $lang['fileTime'] . "</td>";
#$sql = '"'.str_replace('`',"",$sql).'"'; $sql = str_replace('`', "", $sql); #log sql action $basedir = dirname(__FILE__) . "/"; $logfile = $basedir . $env['logs_path'] . $_SESSION['username'] . "_" . $time . ".log"; $etc->LogAction($logfile, "w", $sql . "\n"); # #didn't use sql verification, may cause be hacked if (!file_exists($env['output_path'] . '/hive_res.' . $time . '.out') || filesize($env['output_path'] . '/hive_res.' . $time . '.out') == 0) { #$exec = $LANG . $HADOOP_HOME . $HIVE_HOME . $JAVA_HOME. $env['hive_home'].'/bin/hive '.$UDF.' -e '.$sql.' > '.$env['output_path'].'/hive_res.'.$time.'.out'; $exec = $LANG . $HADOOP_HOME . $HIVE_HOME . $JAVA_HOME . $env['hive_home'] . '/bin/hive ' . $UDF . ' -f ' . $logfile . ' > ' . $env['output_path'] . '/hive_res.' . $time . '.out'; //passthru($exec); #$log = $env['logs_path'].$time.".debug"; #$etc->LogAction($log,"w",$exec."\n"); $runfile = $env['output_path'] . "/hive_run." . $time . ".out"; $etc->NonBlockingRun($exec, $time, $runfile, 2, $code); $etc->ExportCSV($time); } else { echo $lang['cliDone']; } } else { mkdir($env['output_path'], 777); $sql = trim(rawurldecode($query, $key)); $sql = str_replace("", "%", $sql); //decode for like "%" #$sql = str_replace('"','\"',$sql); #$sql = '"'.str_replace('`',"",$sql).'"'; $sql = str_replace('`', "", $sql); #log sql action $basedir = dirname(__FILE__) . "/"; #log sql action